Forum Discussion
ddpl
2 years agoSolution Sage
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_VermaMost 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]- ddplSolution Sage
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 🙏🏽