Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Issue on Excel Input with multiple sheets

  1. #1

    Default Issue on Excel Input with multiple sheets

    I am trying to use Excel Input step on a spreadsheet that has multiple sheets. I notice that data from the first sheet alone gets picked up correctly. The data in the second sheet gets pulled in, under headers from the first sheet. For e.g., I have 2 columns in the first sheet, 11 rows in them. 8 in the second, with just one row. Data in the second sheet show up as though they are in the 12th row, but begin under the columns from the first sheet. Both in preview, and at run time. I am using Build version : 5.2.0.0Build date : September 30, 2014 07:48:28. Has anyone else seen this behavior ? Any thoughts or insights ? Please let me know.

    Thanks,
    Vasu.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    It's no bug, it's a feature.
    So long, and thanks for all the fish.

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.