Compare 2 data sets/excel sheets
- 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 guys,
I'm trying to compare 2 excel sheets to compare what is missing;
Data set 1:
Data set 2:
I need to combine column "Run_Description" and "Batch_Name" in data set 1 and column "Name" and "Batch Name" in data set 2, then do a comparison to see which values are missing between the 2 excel sheets. In data set 2, the columns "Progress" and "User" will need to accompany the results in column "Name" in the output file.
The output should look something like this:
LondonClose_LDB_Onsmile and Custom:LondonClose_LDB_Onsmile are same values, just with an extra Custom in front.
Any help on this would be greatly appreciated
Thanks!
Zayn
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @ZahinOsman,
Here is one way of doing this:
The left of the join indicates they did not match I then add a yes is a missing column. The centre of the join does match so I put No in the missing column.
Any questions or issues please ask :)
HTH!
Ira
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ZahinOsman I got different result after combining the fields Run Name = [Run_Description]+'/'+[Batch_Name] in data set 2 and Run Name = [Name]+'/'+[Batch Name] in data set 1 then joined with them using the join tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks so much guys! Both of you are life savers!
I will play around with this and let you know if I have any further questions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey Ira,
Thanks so much for this. Would you happen to know how I can #Trades, Warning Count, and Total Error Count to the respective Run Names?
So it kinda looks ilke this
Been tinkering around a lot but it keeps flashing up a code error
