Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Excel Input Preview

  1. #1

    Default Excel Input Preview

    Hi All,

    Am creating a transformation to read multiple sheet from .xls file. I'm able to read the file, when i'm doing the preview option, records appears in first two columns. Please find the below snaps.


    3 sheets define in sheets tab.

    Name:  snap 1.jpg
Views: 36
Size:  8.8 KB

    All 3 sheets fields

    Name:  snap2.PNG
Views: 39
Size:  7.0 KB

    Preview windows. Here I have a doubt, why this coming in this format?

    Name:  snap 3.PNG
Views: 34
Size:  7.1 KB

    Highlighted columns data coming in first two columns.

    Help me out of this
    Thanks,
    Magesh

    pdi-ce-4.4.0-stable
    java 1.7.0_25 (OpenJDK
    )

  2. #2

    Default

    Need help..
    Thanks,
    Magesh

    pdi-ce-4.4.0-stable
    java 1.7.0_25 (OpenJDK
    )

  3. #3
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    Bumping your thread does not help!
    I would try selecting only 1 sheet and see if there's the same problem.

    You can always do a Group By and remove duplicate rows after the import.
    -- Mick --

  4. #4
    Join Date
    Nov 2009
    Posts
    688

    Default

    I guess that his sheets don’t have the same columns .
    So Name and Age in sheet A, Address and State in sheet B…
    You can’t put them together in one input step because column A from all the sheets will come in the first field.

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.