Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-16051

Join Rows Step - better handling for identical field names

    XMLWordPrintable

    Details

    • 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

      When using the Join Rows (cartesian product), if the columns on the condition have the same name, the step cannot distinguish between them.
      In this case, columns on the cartesian product returns incorrect values.
      Even when it is documented, it is a common use case to have identical field names for keys in both streams.
      Open the attached transformation and see the results.

        Attachments

        1. countryLatLong.xlsx
          19 kB
        2. merge_Test.ktr.zip
          4 kB
        3. Renewable_CT2000.xlsx
          1.36 MB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              npereira Nuno Miguel Sequeira Pereira
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: