cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
malcek
New Member

expanding column end up with TABLE value

Hello

i'm struggeling with one problem for some time 🙂

I get supplier xml and in some fields there are multiple urls, but when importing with power query it doesent recognize this filed as multiple items in one field and show only Table value instead actual urls

here is how it looks in xml: PowerQuery 
link to picture when edit in PowerQuery: edit power query 

 

 


thanks for any advice

Martin

2 REPLIES 2
malcek
New Member

First thank you for your help.

Inside this column there are additional picture urls. Sometimes you have one additional picture, sometimes none and sometimes two or more and this last combination is problematic. 

This is how it looks in PQ and the code that expands data in column
= Table.ExpandTableColumn(#"Razširjeni TOWARY.PRODUKT.KOLORY.KOLOR", "TOWARY.PRODUKT.KOLORY.KOLOR.zdjecia", {"zdjecie"}, {"TOWARY.PRODUKT.KOLORY.KOLOR.zdjecia.zdjecie"})

malcek_0-1614754273917.png

and inside xml when open it in web browser

malcek_1-1614754345370.png

 

HERE you can also get actual XML

 

PhilipTreacy
Super User III
Super User III

Hi @malcek 

The XML must be in a format that is turned into a table in PQ. What exactly do you want to do?  Extract the contents of these tables?  What data is inside the tables?

Without seeing your real data it's harder to find a solution but i think I'd probably duplicate your query, remove allrows that don't have a Table, then expand all the tables and extact th data you need.

You can then append this data (from the duplicated query) back onto the original query.

Please supply your PBIX file or more help.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors