Forum Discussion
XML to table - seperate columns and rows
I have succesfully run a Soap API call to retrieve XML data however I am unable to parse the data into readable tables due to the column names data being seperate from the row data (as per below) ...
Hi Anonymous ,
Maybe you can refer to this post: Expand Column Containing Some Tables and this blog: Expanding All Columns In A Table In Power Query.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey
Community Support
Community SupportHi Anonymous ,
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Icey
Hi Icey although it looks like some variation of the answers in your links could work, I was unable to manipulate their work to solve mine
In the end I expanded only one side of the tables, pivotted and added new columns to match the column names I didnt expand
I will mark your reply as solved though as I suspect the issue is with my lack of power BI knowledge