Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: One column without header

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default One column without header

    Hello Everyone,

    Here is example: I have 2 columns named "A" and "B", then I have a column without header and then I have one more column "D". PDI only recognizes first two columns. How can I make PDI to recognize all 4 columns?

    Regards,
    Alex

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    Are these columns in Excel? If so, PDI gives hints of the columns based on the header and data content. There's nothing that says you can't define additional fields. The Excel Input step will certainly try to read them when the transformation runs.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you! You are absolute correct. I wish I thought of it!

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.