Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rename some columns by adding a prefix

Hi everyone. I have some tables with aprox. 40 columns. I would like to rename some of these columns by adding a prefix. I have tried Table.PrefixColumns but this adds a prefix to all the columns. I...
Need Help
KNP's avatar
KNP
Super User
4 years ago

Probably, which columns?

Please provide sample data.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, basically I want to achieve this:

    All columns but ITEM, get the prefix "CANT" in their name

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you. It worked really good.

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      4 years ago

      With that information, you can modify what I wrote by creating the list appropriately by changing two lines:  (replace "tbl" with the appropriate table reference

      #"Columns to Prefix" = List.RemoveMatchingItems(Table.ColumnNames(tbl),{"ITEM"}),
Prefix = "CANT",