Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Rename columns that are dynamic

Very good!! I get the data from a CSV by calling a url, but with the problem that that CSV can rename its columns from one day to the next, so I can't automate the normalization of the data in power query. The columns I get are of the type:
market, location, year, periodFrom, periodTo, total, airline:FR, airline:VY, airline:U2, airline:LS, ....., airline:OE, airline:X3, airline:KM

Those "airline" columns are the ones that can vary from time to time that the data is updated, and what I'm looking to do, without much success so far, is to automatically rename those columns and remove the "airline:" and keep only the airline code as a column.

Is it possible to do it??

Thank you very much in advance.