Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change multiple values of multiple columns at once

Hello all,   I am starting to learn m code a little bit more. The problem I have got now is probably very easy to solve but unfortunately at my level of knowledge I am stuck with what I have got al...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    are you sure the code of #"ColumnNames" is correct? it's remove the last 24 column names.

     

    #"Test" =Table.ReplaceValue( #"SourceMod","","",(x,y,z)=>Text.Combine({"ABCD-",x}),#"ColumnNames")

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

are you sure the code of #"ColumnNames" is correct? it's remove the last 24 column names.

 

#"Test" =Table.ReplaceValue( #"SourceMod","","",(x,y,z)=>Text.Combine({"ABCD-",x}),#"ColumnNames")

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, The code of #"ColumnNames" is correct - the table consists of 41 columns and only the first 17 are the ones I want to modify. 

     

    Thank you for your help