Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering Long Table Based on Another Table

 

Hi Guys, how is everything?

I need some help here please. I need to filter a column in a table, long one actually (the first image is a sample of it), to keep only the mentioned names in a column in another table (the second image), to reach the outcome illustrated in the final image (the third image), how could I do that?

 

I think this is reachable thru the "List" concept but I am not pretty sure about the needed script to write, could you help please?

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    On your first table, in the formula bar, type:

     

    = Table.SelectRows(Source, each List.Contains(List.Distinct(Table2[Name]), [Name]))

     

    --Nate

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    On your first table, in the formula bar, type:

     

    = Table.SelectRows(Source, each List.Contains(List.Distinct(Table2[Name]), [Name]))

     

    --Nate

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      That was quick, thanks a million

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I'm sorry for the bothering again.

       

      I've tried to play with the given script a bit and I've applied this:

       

      = Table.SelectRows(#"Changed Type", each List.Contains(List.Distinct(#"Removed Other Columns2"), [Agent]))

       

      Simply, I'm trying to filter a query table using the same query table at different step, isn't this techinically allowed logically speaking? Yet, I'm getting this error:

       

      Expression.Error: We cannot convert a value of type Table to type List.
      Details:
      Value=[Table]
      Type=[Type]