Forum Discussion
Solved
Capture dynamic column name in variable in Power Query
Hi Folks!! I have a excel source file with three columns as shown. ColA Name Address Col A name will change every day, say JAN, FEB etc, there is no exact fixed pattern of change in ...
You can use Table.ColumnNames(#"Previous Step"){0} to get the name of the first column dynamically and use that wherever you would have used the text name of the column. Replace #"Previous Step" with the appropriate step name.
Pat
You can use Table.ColumnNames(#"Previous Step"){0} to get the name of the first column dynamically and use that wherever you would have used the text name of the column. Replace #"Previous Step" with the appropriate step name.
Pat