Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Empty Header row in Excel File

  1. #1

    Default Empty Header row in Excel File

    While reading/input of Excel File, the header row is missing. I would like to detect it first when accessing the Excel file and send to reject folder if there is no header present in Excel file? is there any way I can achieve this? Thanks in advance

  2. #2
    Join Date
    Aug 2013
    Posts
    22

    Default

    Do you know the expected content of your header row? i.e. Field names of columns.

    If so, use the Excel Input step and uncheck the "Header" box. Then read the first row, and use a Filter Step to determine if this content matches your expected Header, else discard.

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.