Forum Discussion
Remove rows which contain data in another Table
Hi all,
I have a data set like below
Fact table
| ID | Content |
| 1 | a |
| 2 | b |
| 3 | c |
| 4 | d |
| sdfsd | e |
| rêtr | f |
| 45 | g |
Dim table
| ID |
| 2 |
| 3 |
| 4 |
| 5 |
| 45 |
| 8 |
Now i`d like to remove all the rows in Fact table which have ID appears in the Dim table ( the values in Dim table are Distinct)
How may i achieved that task?
Many thanks
Hi, Haidannx
Based on my research, the easist way is using 'Merge Queries'. You may go to Query Editor, click 'Merge Queries'.
Then you can make the ID columns from two tables selected and choose 'Left Anti' under 'Join Kind', which keeps only rows from the first table when joining tables.
Finally, you need to right-click 'Dim table' column and remove it. You will get the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, Haidannx
Based on my research, the easist way is using 'Merge Queries'. You may go to Query Editor, click 'Merge Queries'.
Then you can make the ID columns from two tables selected and choose 'Left Anti' under 'Join Kind', which keeps only rows from the first table when joining tables.
Finally, you need to right-click 'Dim table' column and remove it. You will get the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.