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

CSV Input Step Does Mismatching Data to Selected Column Index

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 8.3.0 GA, 9.0.0 GA, 9.1.0 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.
    • Steps to Reproduce:
      Hide

      Run the attached transformation and file. Notice that COLUMN2 is selected in the fields area, but the data is clearly from COLUMN1.

      Show
      Run the attached transformation and file. Notice that COLUMN2 is selected in the fields area, but the data is clearly from COLUMN1.

      Description

      The CSV File Input step has a regression introduced in 8.3. The step allows the user to select specific fields from an input file. However, the step clearly does not honor that anymore. Field 1 is always column 1 from the input file, field 2 input from column 2. In 8.2, it would pull the columns by name that were selected through Get Fields.

        Attachments

        1. CSV_Bug.png
          CSV_Bug.png
          62 kB
        2. CSV_Working_in_8.2.png
          CSV_Working_in_8.2.png
          40 kB
        3. CSV.zip
          2 kB

          Issue Links

            Activity

              People

              Assignee:
              project admin Triage
              Reporter:
              jjarvis Jonathan Jarvis
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: