Forum Discussion
Solved
Filter Columns based on columns' name
Hi all, May I ask is there any way I could filter columns based on its name? ID Group Cost 1 Cost 2 Price 1 Price 2 1 A - 0.8 - -0.11 2 B 0.4 - - 0.23 3 - 0.5 - 0....
= let col=List.Select(Table.ColumnNames(Source), each Text.Contains(_,"Price")) in Table.SelectRows(Source, each List.PositionOf(Record.ToList(Record.SelectFields(_,col)),"-")<0)
wdx223_Daniel Thanks so much. It works perfectly