Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Excel Imput - How to stop on 5 empty rows

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Excel Imput - How to stop on 5 empty rows

    Hello Everyone,

    The structure of my excel files is such that there is no more useful information after 5 empty rows. So I would like to instruct PDI to stop reading after 5 emtpy rows. I see there is an option to stop on empty row which is followed by field "Limit". What does this Limit mean?

    Regards,
    Alex

  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    According to http://wiki.pentaho.com/display/EAI/...orkbooks+(ODS)

    "Limit = Limits the number of rows to this number (zero (0) means all rows)."

    So I read this as the number of rows to be read from the sheet by the input step.

    Cheers,
    Paul

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you!

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.