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

Header checkbox in "Excel Input" step does not work correctly for non-zero Limit parameter



    • Type: Bug
    • Status: Closed
    • Severity: Low
    • Resolution: Fixed
    • Affects Version/s: 3.1.4, 3.2.0 GA, 3.2.1, 3.2.2
    • Fix Version/s: 3.1.5, 3.2.3, 4.0.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Microsoft Windows XP Professional Version 2002 Service Pack 3
    • 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.
    • Browser:
      Internet Explorer 7.x
    • Operating System/s:
      Windows XP


      I'm using Kettle - Spoon version 3.1.0-RC1.

      I'm trying to use the "Excel Input" step in order to read the first row in an Excel worksheet.
      In the Sheets tab I've set Start row to 0 and Start column to 0 for the worksheet I want to read.
      In the Content tab I've unchecked the Header "Check if the sheets specified have a header row that we need to skip." option and I've set the Limit "limit the number of rows to this number, 0 means: all rows." option to 1, but 2 rows are always returned when I press "Preview Rows".
      When Limit is set to a positive value I believe that number of rows must be returned, no matter if Header is checked or unchecked.

      The Header checkbox seems to work correctly (the header row can be excluded or included) if Limit is set to the default value 0 (return all rows).

      A trivial additional problem is that no help text is displayed "in a yellow box" if the cursor is placed on the Header checkbox (such help texts are displayed when the cursor is placed on the No empty rows and Stop on empty row checkboxes.

      I'm also wondering if you think it would be a useful change to let the Header option be a number instead of checkbox (like the Limit option), so the user can specify the number of header rows that ought to be excluded.
      But I'm very new to Pentaho, so I might not yet have understood how you usually handle cases like this in a Transformation (e. g. perhaps a "Filter rows" step can be used to select the first row or a range of rows?).


          Issue Links



              gdavid Golda Thomas
              chum62 Lars Selsbo
              0 Vote for this issue
              0 Start watching this issue