Forum Discussion

z22741's avatar
z22741
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Expand 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...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

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 🙂

YouTube  LinkedIn

 




 

z22741's avatar
z22741
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Fowmy  Thanks for all the helps you offered so far!

 

Don't know why it doesn't work for me. It gave me null for all the rows I expanded.

 

Below is the data have and when I click Table it showed "Element: Text". Not sure if that's why it won't work?