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.  Output Excel : Append data from several files and add a column with input file name

    Employee
    Posted 02-24-2017 05:05

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

    Originally posted by: chetan.b.bagal@willistowe

    Hi,

    I am using Output Excel node which has 13 inputs (exact same columns), It creates a single excel file with 13 tabs.
    Instead I want output to be a single tab with additional column which have the input name in it (currently its tab name).


  • 2.  RE: Output Excel : Append data from several files and add a column with input file name

    Employee
    Posted 02-24-2017 07:10

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

    Originally posted by: stonysmith

    You will want to put all 13 inputs into a CAT node to bring them together into a single stream.
    Unfortunately, CAT won't add the column you need. You'll have to add a filter to each stream to add the column you need... or generate the "TabName" column earlier in the data where you're already processing it.