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

Microsoft Excel Input step - Limit option works incorrectly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 7.0.0 GA, 7.1.0 GA, 8.0.0 GA, 8.1.0 GA, 8.2.0 GA
    • Fix Version/s: 8.3.0 GA
    • 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.
    • Sprint Team:
      Tatooine (Maint)
    • Operating System/s:
      Windows 7 (64-bit)
    • Steps to Reproduce:
      Hide

      Run transformation "test.ktr"

      Show
      Run transformation "test.ktr"

      Description

      Test transformation and input file attached.

      The Limit option: Specify a limit on the number of records generated from this step. Results are not limited when set to zero.

      In Microsoft Excel Input config dialog, I set the following options:

      • Tab Sheet, the Start column as 0
      • Tab Content, the Limit as 10.

      Actual result

      I have the following test cases:

      1. Tab Sheet, Start row is 0; tab Content, Header is checked. Excel Input returns 9 rows
      2. Tab Sheet, Start row is 0; tab Content, Header is not checked. Excel Input returns 10 rows
      3. Tab Sheet, Start row is 5; tab Content, Header is checked. Excel Input returns 5 rows
      4. Tab Sheet, Start row is 5; tab Content, Header is not checked. Excel Input returns 6 rows
      5. Tab Sheet, Start row is 12; tab Content, Header is checked. Excel Input returns 1 row
      6. Tab Sheet, Start row is 12; tab Content, Header is not checked. Excel Input returns 1 row.

      Expected result

      I expect to get 10 rows as per the Limit option in every test cases above.

        Attachments

        1. input.xlsx
          14 kB
        2. test.ktr
          14 kB

          Issue Links

            Activity

              People

              Assignee:
              rrosinha Ricardo Rosinha
              Reporter:
              ngoclong19 Hoàng Ngọc Long
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: