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

Get Files Rows Count step not counting rows correctly?

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 4.2.1 (4.1.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • 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 running the attached KTR with the attached sample files, I get back a row count of 2 when there are actually 4 rows.
      It seems that only EOL delimters are being counted, so if you have a file with only 1 row or no delimiter at the end of the file, the count comes across incorrectly.

      Maybe this is assuming a field header row? If this is the case there should be an option for that.

        Attachments

        1. file-one.gfn
          0.1 kB
        2. file-two.gfn
          0.1 kB
        3. Get Files Rows Count.ktr
          10 kB
        4. RowCount.png
          RowCount.png
          61 kB

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              cboyden Curtis Boyden (Inactive)
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: