LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Combine data from all sheets captured using Directory Node

    Employee
    Posted 03-07-2017 06:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Santosh.Krishnan

    Using a Directory node, I have managed to capture 6 Excel files. However, when I use the 'Excel' Node to then get the data out of those 6 files as a single data set, I am getting the data only from the 1st file. Interestingly, when I add 6 output pins, I am able to get the data from the 6 Excel files to individual output pins successfully. What could be the reason for not being able to get it as a single data set? Appreciate your help! Thanks.


  • 2.  RE: Combine data from all sheets captured using Directory Node

    Employee
    Posted 03-21-2017 02:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: trupthiiyer

    hi Santosh,

    Try using the "MetadataOutputPin" to account for variable worksheets.
    Tim Meagher provides a good explanation in this thread: http://community.lavastorm.com/threa...xcel-file-node

    Another good thread for your reference.

    http://community.lavastorm.com/threa...adataoutputpin