Forum Discussion
Microsoft EmployeeExpand xml file that column has text and table types
Super Userz22741
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 file
You 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 🙂
Microsoft EmployeeSorry 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
- Fowmy
- z22741
The table I have
Id Book 1 Table 2 123456 3 789101 If you click Table, it's a list of Book Id also
Book.Value abc123 def124 ghj125 The end result I expect is
Id Book 1 abc123 1 def124 1 ghj125 2 123456 3 789101 Since I can't find an expand button, I don't know how to get all the data inside of the table
- Fowmy
z22741
Check the steps in the attached file and adjust as per your table. Your tables should look as per Start step.You can download the file: HERE
Your initial table was this:
After Transformation:________________________
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 🙂