Forum Discussion

underkar's avatar
underkar
Frequent Visitor
8 years ago
Solved

Add headers to CSV file

 

Hi all,

 

I have uploaded a CSV file into my PBI project. As the CSV file has no headers, column names in Table1 are shown as Column1, Column2, Column3, ......, Column100.

 

How can I replace those names for the ones that I have defined in Table2.

 

Many thaks for your help

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI underkar,

     

    Based on double check on your snapshot, it seems like your columns are stored in table 2 with original column name and real column name.

     

    For your scenario, I modify my formula to use table 2 columns to generate name parameter list which need to be use in table 1.

    #"Renamed Columns" = Table.RenameColumns(#"Source",List.Zip({Table2[Column],Table2[Description]}))

    Regards,

    Xiaoxin Sheng

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI underkar,

     

    You can use List.zip, Table.Renamecolumns and Table.ColumnNames functions to auto rename one table names based other table.

     

    Sample:

     

    #"Renamed Columns" = Table.RenameColumns(#"Previous Step",List.Zip({Table.ColumnNames(#"Previous Step"),Table.ColumnNames(Sheet2)}))

     

    Regards,

    Xiaoxin Sheng

    • underkar's avatar
      underkar
      Frequent Visitor
      8 years ago

       

      Hi Anonymous, thanks you very much for your reply.

       

      I think this code doesn't work in my example, because I don´t need to replace headers in "table1" with headers in "table2", what I need is to lookup Column1, Column2, etc in "table2" and return the text in column "Description" of "Table".

      I hope I have explained this better....

       

      #"Renamed Columns" = Table.RenameColumns(#"Source",List.Zip({Table.ColumnNames(#"Source"),Table.ColumnNames(Table2)}))

       

      Many thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HI underkar,

         

        Based on double check on your snapshot, it seems like your columns are stored in table 2 with original column name and real column name.

         

        For your scenario, I modify my formula to use table 2 columns to generate name parameter list which need to be use in table 1.

        #"Renamed Columns" = Table.RenameColumns(#"Source",List.Zip({Table2[Column],Table2[Description]}))

        Regards,

        Xiaoxin Sheng