JOIN 2 FILES AND MARK THEIR ORIGIN IN NEW COLUMNS

[dianastate]

Hi!

I am trying to join 2 excel files ( FILE 1 and FILE 2) which contain some product codes. Those product codes might repeat themselves. I want to create a new file by joining them, however, in the new file, I don't want duplicates ( each product code has to be unique) and I need 2 new columns to be created, in which it is marked with an "Yes" if that product code is coming from File 1 and/or is coming from File 2.

I have attached an example.

I would appreciate very much if you can help me guys! 

Thank you !!!

[binuacs]

@dianastate One way of doing this

[dianastate]

Hi!

Thank you so much for the fast response!

I have tried it and it works!

I have 1 more question, if that's all right: in practice, the files contain other columns which are descriptions of the product codes. For example

Product Code	Name	Color	Price
AAA	AirTag	White	100$

Although I have followed the workflow that you presented, in the final output I'm not seeing those extra columns. By backtracking the workflow, I saw that it's because of the Cross Tab.

Do you have any idea how to also pull those columns in the final output?

Thank you so much!!

[binuacs · Accepted solution]

@dianastate I updated the workflow let me know if you are looking for a different output

[Dev73]

Hi @dianastate - Here is one more solution