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.

        PractiTest Integration




          Attachments

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

            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: