JOIN 2 FILES AND MARK THEIR ORIGIN IN NEW COLUMNS
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 !!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
