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.  How to create a column in the output of a Delimited File node that has the FileName

    Employee
    Posted 12-15-2014 23:44

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

    Originally posted by: snbkumar

    Hi Team,

    I have 5 input files that I am pulling using Delimited Files node. I would like each transaction of the respective files to have the filename against them as a separate column.
    Eg:
    Delim1 has filename=F1.dat and has 4 transactions
    Delim2 has filename=F2.dat and has 3 transactions
    Delim3 has filename=F3.dat and has 9 transactions

    When I combine the data using Cat, I want to see all 16 transactions with an extra column that has the respective file names.

    Appreciate your immediate response.

    Thanks,
    Bharath


  • 2.  RE: How to create a column in the output of a Delimited File node that has the FileName

    Employee
    Posted 12-15-2014 23:56

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

    Originally posted by: andycooper

    Hi Bharath,

    On the output tab of the Delimited File Node there is a field called FileNameOutputField, if you populate this with a name (e.g. File) then this will output the filename and path.

    Thanks

    Andy


  • 3.  RE: How to create a column in the output of a Delimited File node that has the FileName

    Employee
    Posted 12-21-2014 17:04

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

    Originally posted by: snbkumar

    Yes. Got that few days ago after some "playing around". Thank you Andy