Help Centre

Append File Name
Append File Name creates a new column containing the name of the stage input file from which the row originated. This may be required when the file name contains important information, such as reporting date, and is useful for tracing data errors. Note that the appended file name is the stage input name, which could be the output of another stage.
There are no configurable variables in this operation.
Example
Monthly data from Newco has been uploaded. The file name contains a date, so has been added in a new column using the Append File Name operation.
ID
Supplier
File name
1
Newco
Newco-policies-2017-09.xls
2
Newco
Newco-policies-2017-10.xls
3
Newco
Newco-policies-2017-11.xls
4
Newco
Newco-policies-2017-12.xls
An Extract Date operation can now be run on the ‘File name’ column to extract a clean date.