How to convert the data entry where rows have uneven entry within xml into a table?

Question

Praful Upadhyay 2021-12-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1608070-how-to-convert-the-data-entry-where-rows-have-uneven-entry-within-xml-into-a-table

回答： Divyanshu 2024-2-27

While running the code on this data the centroid which is a variable has 385 entries, in which there are three variables. However on some rows there are four variables example on row number 12. There is entry of variable with name 1event. The loop stops at row 12 and give a error mentioned in the above picture. You can also see ME exception.

Thanks for your consideration.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Divyanshu 2024-2-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1608070-how-to-convert-the-data-entry-where-rows-have-uneven-entry-within-xml-into-a-table#answer_1417263

Hi Praful,

The reason you are getting this error 'All tables being vertically concatenated must have same number of variables' is because table is a structured data and cannot have different number of columns in different rows.

A possible workaround can be :

Create a table with number of columns equal to maximum variables of all the entries of XML file.
Now for each item on xml file create a row and fill the variables/columns with values.
If the current item is having less variables than maximum, you can fill those columns with '-'.

Hope it helps!