Add headers to CSV file

[underkar]

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

[v-shex-msft · Accepted solution]

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

[v-shex-msft]

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]

Hi @v-shex-msft, 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

[v-shex-msft · Accepted solution]

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 · Accepted solution]

Thanks Xaoxing!! It works!