Identify where joined column comes from

[wonka1234]

Hi all,

Is there a way to rename columns or add a prefix of the filename to the column?

I am doing a join and would like a better way to identify where the column comes from other then "left" or right".

ie I'd like to rename,   [File1]_Person  or [File2]_Person

Any help would be appreciated.

[Luke_C]

@wonka1234 Open with notepad and update to your version. Should work after that.

[wonka1234]

@Luke_C  I have two summaries, now need to append it from both sides.

[Luke_C]

Hi @wonka1234 

You have a lot of great solutions in this thread, take a look and try applying them to your situation. That's the best way to learn! If you run into specific issues we can help.

[wonka1234]

@JosephSerpis Hi Joseph,

When i try recreating im only getting one set of the col names renamed:

I am unioning both:

[JosephSerpis · Accepted solution]

Hi @wonka1234 its hard to tell from the screenshot and not having the workflow however the formula tool for the Right columns I ensure have Right_ infront the columns names.

This means that the union has two fields Name that will match up from the results of the Join tool when it adds Right_ and the Replacement column which I use in the dynamic rename tool.