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}&")"})

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

    wdx223_Daniel ,

     

    Now whenever the value changes column name changes, this is working fine but when i click on close and apply visual is getting error because column name got changed right. Is there any way to handle this situation?

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

        sorry, have no idea to resolve this.