Details

    • Type: Bug
    • Status: Open
    • Severity: Unknown
    • Resolution: Unresolved
    • Affects Version/s: 9.1.0.3 GA
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      0
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Some troubles are present to use MERGE JOIN STEP, first data source is a txt file, the second one is a SELECT QUERY POSTGRESQL TABLE INPUT.

      In each streams, I sorted asc and desc for check the results, but in two cases I have rows that can't join, I reviewed directly the data in SQL table and the value exist.

      I trim these fields, the value is exactly the same, but it couldn´t join.

      I realized that when sorted DESC the result is better than ASC, but is not success.

      I checked the join's result loading txt data on another table in PostgreSQL and doing query select * from inner join, and there was matching.

       

        Attachments

          Activity

            People

            Assignee:
            BjlvX Brian
            Reporter:
            BjlvX Brian
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: