Log In
Register
Home
June 1, 2018
Offline
I imported xml through power query, the expanded columns contain [Table], 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
October 5, 2010
Offline
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
1 Guest(s)
