Forum Discussion

amsrivas's avatar
amsrivas
Icon for Helper IV rankHelper IV
5 years ago
Solved

Capture dynamic column name in variable in Power Query

Hi Folks!!

I have a excel source file with three columns as shown.

 

ColANameAddress

 

Col A name will change every day, say JAN, FEB etc, there is no exact fixed pattern of change in column name, it can be any Month name any time.

 

I want to capture this name of column in any variable say varA.

 

I have tried to use Parameter but parameter value is not chaning by its own even source got refreshed, i can understand, in Parameter we need to change value manually.

 

Is there any way out to capture the value of column in varA and that variable can be utilised further.

 

Thanks

Amit Srivastava

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    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