Forum Discussion

ddpl's avatar
ddpl
Solution Sage
2 years ago

Filter nested table by nested list...???

I have 2 tables

d:

 

up:

 

in d Table

1) Split by comma and get list : Text.Split([d], ",")

2) Join whole 'up' Table at each row : each up

3) Filter up[up] column to each item inside list :

     let
     l = [d1]
     in
     Table.SelectRows([tab1], each (List.Contains(l, [up])))

 

but my M code filter only single/first item of list to column

I want all the items of list to filter up[up] column whichever are present.

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    Insert this step (modify Source appropriately)

    = [a = List.Combine(List.Transform(d[d], each Text.Split(_, ", "))), 
    b = Table.SelectRows(Source, each List.Contains(a, [up]))][b]

     

    • ddpl's avatar
      ddpl
      Solution Sage

      Vijay_A_Verma 

      I'm sorry but I can't comprehend your code, and It throws error when I applied it.

      Can you please give me code more explicitly 🙏🏽