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...
Fowmy
Super User
Super User
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
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 🙂