Forum Discussion

z22741's avatar
z22741
Icon for Microsoft Employee rankMicrosoft Employee
6 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 can find but it didn't work.

 

 

Are there any other ways to solve this?

 

Thanks

Need Help

8 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    z22741 

    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 🙂

    YouTube  LinkedIn

    • z22741's avatar
      z22741
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      Fowmy 

      Thanks for getting me back. I actually need the data inside the table. Do you happen to know how to do that?

      • Fowmy's avatar
        Fowmy
        Icon for Super User rankSuper User
        6 years ago

        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 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 🙂

        YouTube  LinkedIn