expanding column end up with TABLE value

[malcek]

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

[malcek]

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"})

and inside xml when open it in web browser

HERE you can also get actual XML

[PhilipTreacy]

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