Power Query delete row if value found in another column

Like (0) Share

Report

Posted on 12 Dec 2023 19:32:52 by bsheri80

Hi, I’m very new to power query but just can’t find a suitable solution. I need to remove a row if the same value exists in another column. I know I need a conditional statement then a filter but just don’t know how to put it all together. So if ID B exists in ID A remove the corresponding ID A row.

ID A. ID B

1
2

4 1

5 3

so here the first and third row in ID A would be removed. I would want to keep the row where the value is duplicated in ID B

thanks for any advice.

All responses (2)

Answers (0)

bsheri80 4 on 18 Dec 2023 at 21:51:09

Like (0)

Report

Re: Power Query delete row if value found in another column

Thanks - I'm still getting my head around all the functions available so good to know some new ones.
bsheri80 4 on 18 Dec 2023 at 21:50:29

Like (0)

Report

Re: Power Query delete row if value found in another column

Thanks, I appreciate you explaining the logic behind it. Really useful.