Using list as a filter in query editor

[klehar]

can i use a list in query editor to filter rows in another table?

I dont want to use a join and then remove the columns

[Idrissshatila · Accepted solution]

Hello @klehar ,

check this out https://youtu.be/KnvSAAqfUX0?si=bdEt9z0FPGKipEpp

https://youtu.be/eB-LBLS-BRg?si=g5f1f-4_Qb-xg2eL

[klehar · Accepted solution]

Solution

= Table.SelectRows(#"Changed Type", each List.Contains(op,[op list])=false)

[Idrissshatila · Accepted solution]

Hello @klehar ,

check this out https://youtu.be/KnvSAAqfUX0?si=bdEt9z0FPGKipEpp

https://youtu.be/eB-LBLS-BRg?si=g5f1f-4_Qb-xg2eL