Filter based on values from other query

[The_Stein]

I'm trying to filter a column based on the values from another query or List.

Step 1: Filter  Column 1 = null   -  = Table.SelectRows(#"Expanded Sheet1 (2)", each ([JOURNAL_NAME] = null))

Step 2: Filter Accounts based on Distinct list in another table/Query

Table/Query 1 - #"Delta Filter".Account

Filter values that are in #"Account Codes Distinct".Account  (Distinct List)

Step 3: Similar to Step 2 but now filter on the Product Codes

I can not get Step 2 or 3 to work.  I've tried List.Contains function and table functions.  I'm open to creating a new column to show true false on the match.  

Thank you.  #Beginner 

[Anonymous]

Hi @The_Stein ,

I agree with @ImkeF . When you need to do something based on other tables , the easiest way is to Merge these tables then expand columns , and after doing transformation , remove the unnecessary columns.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF]

Hi @The_Stein ,
I would merge these queries in the modus of an inner join.
This will effectivly work as a filter where entries on both merge columns must match.