Help Centre

Append Filename
Append Filename creates a new column called ‘filename’ containing the name of the stage input file from which the row originated. This may be required when the filename contains important information, such as reporting date, and is useful for tracing data errors. Note that the appended filename 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 filename contains a date, so has been added in a new column using the Append Filename operation.
ID
Supplier
filename
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
A Regex operation can now be run on the ‘filename’ column to extract the date component.