Forum Discussion
z22741
Microsoft Employee
Microsoft EmployeeExpand xml file that column has text and table types
Hi, I import an XML file and all columns can be expanded in the UI. However, one of the columns contains both text and table types that I can't see a data drill button. I've tried any methods I c...
z22741Microsoft Employee
Microsoft EmployeeThe 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
Super User
Super Userz22741
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 š