New Column need to be added in workflow

[Kavya432]

Hi Team,

I need to added a new column Called "Source".I want to tell like from which source its coming from

For Example: In the attached workflow there are different input files. For each input file I need to add a Column as Source.

Source='Fugent'

Source='iDrive'

etc like this for all input files.

Appreciate the solution folks.

Basically I am trying to union all that input files or data coming from same database.

[NicholasM]

Hey @Kavya432 ,

This functionality is actually built into the input data tool. You can simply change it to output the file name as a field. See photo below. 

[BrandonB · Accepted solution]

You can make a quick change to your formula to resolve this. Right now you have a formula creating a column called "Dist". The syntax of this formula just needs to be rewritten, but you are close! Instead of saying Dist = 'Fugent" you can just have the expression say 'Fugent'. Proper syntax is shown in the second screenshot. @NicholasM also has a good idea of just outputting the file name from the input tool which would eliminate the need for the formula.