Forum Discussion

The_Stein's avatar
The_Stein
New Member
4 years ago

Filter based on values from other query

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 

Need Help
Tutorial Requests

2 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    4 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.