Forum

Power query - expan...
 
Notifications
Clear all

Power query - expanded column contains Table

2 Posts
2 Users
0 Reactions
120 Views
(@tinak)
Posts: 39
Trusted Member
Topic starter
 

2022-07-13_16-40-06.pngHi

I imported xml through power query, the expanded columns contain

, they are all empty. I don't know how to convert it to correct data type, all columns are ABC123.

please refer to the attachment.

 

Thanks!

Tina

 
Posted : 14/07/2022 2:45 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Tina,

Can you please supply the XML?  Without this it's hard to give you anything other than general guidance.

When you have a column full of tables the column header will have a double headed arrow that when clicked, allows you to extract the data in the tables.

Your columns have a mixture of tables and values so you can't expand the tables in this way.

If you don't need the values, you could remove those rows, leaving you with just the tables which can be expanded.

Or if you know what data you want from the tables, you could use some M code to extract the this into a new column.  But, without knowing the structure of the tables (defined by the XML) I can't say how to do this.

Regards

Phil

 
Posted : 14/07/2022 7:21 pm
Share: