Remove rows which contain data in another Table

[Haidannx]

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

[Mariusz · Accepted solution]

Hi @Haidannx 

You can use Merge Queries with Left Anti Join Kind as below

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[v-alq-msft · Accepted solution]

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.

[Mariusz · Accepted solution]

Hi @Haidannx 

You can use Merge Queries with Left Anti Join Kind as below

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn