Expand xml file that column has text and table types

[z22741]

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

[Fowmy]

@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]

@Fowmy 

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

[Fowmy]

@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

[z22741]

Sorry 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 

Not quite clear about what exactly is needed, can you provide an example?

________________________

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]

@Fowmy 

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 🙂

YouTube  LinkedIn

[z22741]

@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?