Forum Discussion

Haidannx's avatar
Haidannx
Helper I
6 years ago
Solved

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   N...
Need Help
Show and Tell
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    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's avatar
    v-alq-msft
    6 years ago

    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.

     

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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.