Forum Discussion

HemanthV's avatar
HemanthV
Icon for Helper II rankHelper II
4 years ago
Solved

Concatenate cell value to Column Name

Hi Guys,   I have data like below   CountryCityPeriod A aa P8 A bb P8 A cc P8 A dd P8 B ee P8 B ff P8 B gg P8 B hh P8 B ii P8 C jj P8 C kk ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep= Table.RenameColumns(PreviousStepName,{"City","City ("&PreviousStepName[Period]{0}&")"})

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

NewStep= Table.RenameColumns(PreviousStepName,{"City","City ("&PreviousStepName[Period]{0}&")"})