Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Get fields from excel when the header is not the first row

  1. #1
    Join Date
    Jun 2010
    Posts
    114

    Question Get fields from excel when the header is not the first row

    I am trying to do a basic thing like loading data from an excel sheet.
    Is there a way to ignore the rows until we meet the header line and then grab the fields?

    For instance, the first two rows of the excel sheet attached are to be skipped.

    Do we have any option to do that?

    Thanks,
    Om
    Attached Images Attached Images  

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    You can specify a different starting row (2 in this case) next to the sheet name.
    If you're reading all sheets, simply leave the sheet name blank.

  3. #3
    Join Date
    Jun 2010
    Posts
    114

    Smile

    Thanks Matt

Tags for this Thread

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.