Forum Discussion
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 point in time later there will be new column added "Calculation XXX Feb" and so on.... there can be a lot other tables with different names added in between so they are not next to each other or even the last one.
How can I find that last column name knowing that only "Calculation XXX" is common header name string ? Sorry if this is obvious but couldn't find the answer also unpivot didn't work for me. Thanks
Use this to find last column names starting with "Calculation XXX"
= List.Last(List.Select(Table.ColumnNames(Source),(x)=>Text.StartsWith(x,"Calculation XXX")))
2 Replies
Use this to find last column names starting with "Calculation XXX"
= List.Last(List.Select(Table.ColumnNames(Source),(x)=>Text.StartsWith(x,"Calculation XXX")))Thanks Vijay_A_Verma ! Works for me.
