Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables - One contains the master data and other contains a subset of that data that shouldn't be there. I cannot easily filter out the data from the master table because it's based on a number of criteria that are not captured in the data. I would like to do opposite of Append. I want to perform a join based on matching values in a column and remove all rows in the master table that are in the second table.
so basically if I have table A and Table B, if [columnA.tableA]=[columnA.tableB] then subtract that row.
I did Left Anti merge but that merges the two tables and not subtract it. I don't want to add columns.
How do I do this?
Thx.
Solved! Go to Solution.
Ok.. Left -anti worked. I basically merged the two horizontally and then deleted all the extra columns there were created after the merge to get back original columns. Left-anti only gave me the rows that had matching rows based on the column I selected.
HI @Anonymous
I think you are on the right track by merging the two tables horizontally. I think the next step is to filter out any rows from the merged table where its columns in the merged side are NULL (as in they found no match). This should filter out rows that did match and leave you with the exceptions.
Ok.. Left -anti worked. I basically merged the two horizontally and then deleted all the extra columns there were created after the merge to get back original columns. Left-anti only gave me the rows that had matching rows based on the column I selected.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |