Adding fields to identify source data in

Question

Is there a way to manually add a field column in the union tool in order to identify the source data?

So if I have two inputs, say A and B, connecting to the union tool, how would I manually add a column that would identify which data input each row has?

MichaelLaRose · Accepted Answer

Hi @OmarH ,

Not in the union, but you can add a formula tool immediately before the union to add an identifier field.

Just make sure that you add a new column with the same name you should be fine.

Best,

Michael

grossal · Accepted Answer

Hi @OmarH,

you'd add a Formula Tool in every data stream in front of the Union Tool to add a column like 'Source' with different information for each data stream.

Best

Alex