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

StaxPoiSheet creates an additional object with null when it encounters a null field

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 7.1.0 GA, 8.1.0 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: Step
    • Labels:
    • 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
      • Feed it data looking like this:
        Header1,Header2,Header3,Header4,Header5
        Data21,Data22,,Data24,Data25
        

        What comes out is:

        [Data21,Data22,null,null,Data24,Data25] 
        

      It's clearly wrong - two nulls instead of one.

      Show
      Feed it data looking like this: Header1,Header2,Header3,Header4,Header5 Data21,Data22,,Data24,Data25 What comes out is: [Data21,Data22,null,null,Data24,Data25] It's clearly wrong - two nulls instead of one.

      Description

      From the PR Description:

      Header1,Header2,Header3,Header4,Header5
      Data11,Data12,Data13,Data14,Data15 => cells arraylist holds 5 objects [Data11,Data12,Data13,Data14,Data15] =>Correct
      Data21,Data22,,Data24,Data25 => cells arraylist holds 6 objects [Data21,Data22,null,null,Data24,Data25]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              scosta Sandra Costa
              Reporter:
              mbatchelor Marc Batchelor (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: