Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This might be quite easy to solve but I'm stuck with this for a while now.
I've got this "simple" estructure coming from a XML file:
headers | data |
name,surname,address,city,phone | John,Smith,Baker st. 21B,London,3758 |
name,surname,address,city,phone | Carol,Newman,Picadilly 23,London,5663 |
name,surname,address,city,phone | Bernard,Collins,7th Avenue 432,NYC,3456 |
and obviously what I would like would be something like:
name | surname | address | city | phone |
John | Smith | Baker st. 21B | London | 3758 |
Carol | Newman | Picadilly 23 | London | 5663 |
Bernard | Collins | 7th Avenue 432 | NYC | 3456 |
Now take in consideration that we're talking about millions of rows and there are more headers than in the example, so performance matters here. Please, could anybody provide any tips? Thanks!
Solved! Go to Solution.
in Query editor you can add custom column like this
Record.FromList(Text.Split([data], ","), Text.Split([headers], ","))
and then expand the new column
in Query editor you can add custom column like this
Record.FromList(Text.Split([data], ","), Text.Split([headers], ","))
and then expand the new column
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |