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. countryLatLong.xlsx
            19 kB
            Nuno Miguel Sequeira Pereira
          3. Renewable_CT2000.xlsx
            1.36 MB
            Nuno Miguel Sequeira Pereira

            Issue Links

            is related to

            Bug - A problem which impairs or prevents the functions of the product. PDI-13227 join rows step - after changing the steps on incoming hops, step gets into undefined / not working state

            • High - An issue that impacts and reduces ability to use Pentaho in a production environment. Business operations are able to continue, however they may be highly impacted and a viable documented workaround is not available.
            • Closed
            relates to

            Improvement - An improvement or enhancement to an existing feature or task. PDI-7928 As an ETL developer I want be able to select the output fields and their order in the Join Rows step

            • Medium - An issue that impacts the ability to use Pentaho in a production environment but business operation is able to continue, although it may, to a certain extent, be hindered. A viable documented workaround exists for the issue and can be used in a production environment.
            • Closed

              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: