Power Query: Filtering columns based on text content

[studioacosta]

I want to filter and keep only the columns that contain a specific project number anywhere in the data cells (not in the column name). I'm struggling to figure out how to do that - I thought a Table.SelectColumns function would work with Text.Contain but I can't get it to work. Am I on the right track? Is there a better way?

 

[Sergius]

You can use "Table.Selectrows"

 

[studioacosta]

You can use "Table.Selectrows"

Sorry not sure I understand - how would table.selectrows be applied in this instance? I'm aiming to filter columns...

 

[AlienSx]

@studioacosta, you need to feed Table.SelectColumns with a list of column names. So you start with Table.ColumnNames list and you need to select names that conform to your condition:
List.Select(Table.ColumnNames(tbl), (x) => func(Table.Column(tbl, x))) where func is function that accepts a list of values and checks for you condition. So it gives ether true or false.

 

[studioacosta]

@studioacosta, you need to feed Table.SelectColumns with a list of column names. So you start with Table.ColumnNames list and you need to select names that conform to your condition:
List.Select(Table.ColumnNames(tbl), (x) => func(Table.Column(tbl, x))) where func is function that accepts a list of values and checks for you condition. So it gives ether true or false.

Thanks! Once I ended up adding a hidden row to the top of the timesheet that contained the data I needed to filter by, I was able to get what I needed.