New Column need to be added in workflow

Question

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.

LMS data.yxmd

BrandonB · Accepted Answer

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.