How to compare column of two sheets
Hi
I have a need where I need to compare value of specific column from two different sheets of a workbook and identify all records of first sheet which doesn't have matching value in corresponding column of second sheet.
Can we do that in datameer?
Thanks
Sanjeev
-
Hi Sanjeev, yes, this can be done in Datameer.
You'll want to start by performing a Left Outer Join of the first sheet to the second. Use the specific column you mentioned as the join criterion. On the Join results sheet, simply filter for records with an empty value for joined columns from the second sheet.
Please sign in to leave a comment.
Comments
1 comment