LAE

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

Originally posted by: ericbrazis

Is there a way to display the source file name? Right now we are importing data in and would like to see if there is a way to display the source file name for each line of data in a new cell. For example, would like it to read as

John Smith testfile_A.csv
Jane Doe testfile_B.csv
John Doe testfile_B.csv
Jane Smith testfile_C.csv

Any help is appreciated. Thanks!

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

Originally posted by: stonysmith

The CSV node and the Delimited File node both have FilenameOutputField. Just specify a column name there and you'll get the filename that the record came from.

The Excel file reader has another method:
<generatedFields>
<field type="filename" />
</generatedFields>

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

Originally posted by: ericbrazis

Perfect, thank you very much!