JOIN 2 FILES AND MARK THEIR ORIGIN IN NEW COLUMNS

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 !!!

Screenshot 2023-05-09 at 15.25.37.png

Workflow

Developer Tools

Input

Tips and Tricks

Custom Tools

Macros

Connectors

Common Use Cases

Best Practices

Join

Accepted answers

binu_acs

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

Join_090523.yxzp

All comments

binu_acs

@dianastate One way of doing this

Join_090523.yxzp

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!!

binu_acs

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

Join_090523.yxzp

Dev73

Hi @dianastate - Here is one more solution

test.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703