Forum Discussion
Solved
Search column name headers by name (like)
Hi there, I am searching advice how can I find column name by the header where I know the header partially. For example: I have one column header called "Calculation XXX Jan", and on some poi...
Use this to find last column names starting with "Calculation XXX"
= List.Last(List.Select(Table.ColumnNames(Source),(x)=>Text.StartsWith(x,"Calculation XXX")))
Use this to find last column names starting with "Calculation XXX"
= List.Last(List.Select(Table.ColumnNames(Source),(x)=>Text.StartsWith(x,"Calculation XXX")))