Power query nested table

Viewed 245

I have xml file that i need to process. My output look like this :

enter image description here

In the nested table there is only one value but i cant figure out how to ungroup them.

1 Answers

Add a column and insert the following M (replacing channel.item.ht with whatever your column name actually is).

if [channel.item.ht] is table then Record.ToList([channel.item.ht]{0}){0} else [channel.item.ht]

Related