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
Back to discussions
Expand all | Collapse all

Concatenate fields across CSV/delimited files with FilenameExpr

  • 1.  Concatenate fields across CSV/delimited files with FilenameExpr

    Employee
    Posted 06-30-2015 12:01

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

    Originally posted by: ryeh

    In the Excel File node, you can specify the "Concatenation Type" so that fields across the files can be appended without having to be exact. I would like to do the same with the CSV File or Delimited File node.

    I used a Directory List node to pull in the files I want to read in. I tried using Ernest's 'Do For Each Record' node to then parse each record. The problem is that when concatenating, the Output BRD File is used (with Append = true), and that doesn't allow for union of fields.

    My next idea was to use the Cat node to concatenate the aforementioned BRD file (now with Append = false). This would potentially be a data volume nightmare, but I'm just looking to get something to work. The problem here is that I can't, i.e. don't know how to, initialize it for the first loop. Any ideas/suggestions?