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
    8 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
    8 years ago

    Thanks Xaoxing!! It works!

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
8 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
    8 years ago

    Thanks Xaoxing!! It works!