Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Getting Header data for a Excel File with dynamic fields

  1. #1

    Lightbulb Getting Header data for a Excel File with dynamic fields

    Hi

    I have a tabular data in excel which has a header.

    The header length & its names are not constants and change with time.

    Is there a way that Excel input can dynamically find the header information when we had defined a transformation without using "Get Fields" from the Excel Input?

  2. #2

    Default

    I have the same issue! did you find a work around. This scenario works well with the Excel Output Step (xls), but it does not work with the Excel writer (xlsx), you have to specify the fields in order to be able to export the header.

    Regards,

    Benjamin

  3. #3
    Join Date
    Dec 2010
    Posts
    193

    Default

    Hi,

    Can you please try this link http://www.ibridge.be/?p=194. Also, if it is possible , convert the excel file into text file and then use this concept http://www.ibridge.be/?p=273 (Its working well)
    Sathish
    Back to Pentaho


    'Be the best Pearl in the ocean of wisdom'

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.