Forum Discussion
Microsoft EmployeeExpand xml file that column has text and table types
Super Userz22741
If you filter only table and try, it should work. Since the column has mixed data types, the expand option isn't active.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Microsoft EmployeeThanks for getting me back. I actually need the data inside the table. Do you happen to know how to do that?
- Fowmy
z22741
I recreated your scenario and managed to expand the table after removing non-table rows. check the steps after Converted to the Table in the attached fileYou can download the file: HERE
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
- z22741
Sorry I didn't have my question clear. I'd love to keep all data together. For example, the end result should have row 3, 5 in figure 1 + figure 2 all the data.
If this' the data I have
and this will be if I clicked the table and what the data looks like. Only a list of data