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 re...
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

  • underkar's avatar
    underkar
    7 years ago

    Thanks Xaoxing!! It works!

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

underkar's avatar
underkar
Frequent Visitor
7 years ago

Thanks Xaoxing!! It works!