Forum Discussion
ddpl
Solution Sage
2 years agoFilter 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 ins...
Vijay_A_Verma
Most Valuable Professional
2 years agoInsert 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]
- ddpl2 years ago
Solution 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 🙏🏽