Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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
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
Thanks Xaoxing!! It works!