Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |