Compare 2 data sets/excel sheets

ZahinOsman

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

Data set 1.xlsx

Data set 2.xlsx

IraWatt

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

Workflow.yxmd