Adding a column in the output file according to the input file

[Nikkhil]

Hi,

I have a few CSV files being sent by different systems. They are differentiated by the file name for example - file for system 1 and system 2 has name - file_system1.csv and file_system2.csv respectively. The files have same number of columns. 

The problem is that we have to manually add a column - Source_System, in each file before consolidating the files into one file. Is there a way to achieve this in Alteryx?

Thank you!

[ChrisTX · Accepted solution]

In the Input Data tool, use the option for "Output File Name as Field".  Then use a Formula tool to get your System name from the file name.

Chris

[Nikkhil]

Thank you, Chris. This is very helpful.