Create new column based on which dataset the row is coming from

[srk0609]

I created a union of 2 same tables I want to create a new column that would have value A if the row comes from Dataset A and value B if the row comes from Dataset B. I'm attaching the screenshot of the wf, output. Can you please help me create a new col? Thank you. I'm using yxdb files as i/p in actual wf.

record	col 1	col 2	new col
1	20	100	A(COS COMING FROM 1ST TABLE)
2	30	200	A(COS COMING FROM 1ST TABLE)
3	20	100	B(COS COMING FROM 2ND TABLE)
4	30	200	B(COS COMING FROM 2ND TABLE)

[binuacs · Accepted solution]

@srk0609 Add formula tools after the input tools, create a column and update the value "Value from DataSetA" and in the next formula tool "Value from DatasetB" then union the results