Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
82
Views
Topic starter
I have the data, comes from an SQL server, comes with the name Table1.field1,Tabale.field2 and so on for about 70 columns. How do I replace the columns name into field1, field2 and so on by using the Power Query?
Posted : 25/04/2020 1:12 am
Hi Charles,
Transpose the table so the column labels are now in a single column. Then you can split the column to remove the .field part of the name. Then transpose back to the original layout.
Mynda
Posted : 25/04/2020 6:20 am
