Treating differently named headers in multiple files as one

[Benkov]

Hello everyone,

I am facing a tricky problem. I have multiple csv-s in a folder with headers in different languages, which contains the same type of data:

So A = Q; B = W; C = E.

Is there a way to import them as one without making a query for each different type of header and then appending them?

Thank you in advance!

[v-shex-msft · Accepted solution]

Hi @Benkov,

I'd like to suggest you add a mapping name table, then you can use it as parameter to use in change names step to achieve dynamic rename at the query editor side.  Then you can simply merge these table with same data structures.

Solved: Dynamically changing name ofthe column header - Microsoft Power BI Community

Regards,

Xiaoxin Sheng