Forum Discussion
matching rows in complex data set
I have some large data sets that i need to query to isolate specific data rows. Each row is identified by a date-based designation, with many columns of data following the date. There may be 300...
Hi FishDoc ,
I used power query on your sample file:
Step 1:
Made your exclusion list into an excel table, and did a power query on it:
Step 2:
Defined the Dataset into an excel table, and did a power query on it:
Step 3:
Did a Merge Query:
When you get to this dialog box I selected the Exclusion list as the Left (top)
and selected the Dataset as the right (bottom), then selected the Anti-Right Join,
meaning only show the rows in the Right table that does not match the Left table.
The result:
File is attached.
Cheers