Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: When my input file 0 byte is (--> 0 rows)

  1. #1

    Question When my input file 0 byte is (--> 0 rows)

    Hello,

    1)
    I have a Step: ‘fixed file input’. Input files with 0 bytes (0 rows) are possible.
    In a case when my input file 0 byte is (è 0 rows), I expect then the follow stream with 0 rows is. However the stream after reading the 0-byte file has 1 “blank” row. Last produce (through a ‘Table output’ step) in my result- table (mySQL) one “blank” rows. Unwilling! How can I avoid that?

    2)
    How can I count the rows in a stream? (I need that when my file more then 0 row has as well.)

    Thank you very much in advice!

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    1) is not true... Just tried it on 3.1 trunk version. An empty input file will result in no output rows.

    2) use a group by step.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.