XML, expand tables nested within cell

[gelu]

Hello Connoisseurs,

I am trying to import an xml table from this address - https://scsanctions.un.org/resources/xml/en/consolidated.xml

I have 4 difficulties/help requests,

1. Is there a technique to expand both Individual and Entity at once?
2. Is there a technique to expand all columns at once?
3. Is there a technique to expand the tables within cells as rows in the big table? Can all of them be expanded at once?

Details below:


First difficulty - Expand All Tables at once

1 - I First expand Individual

2 – Then I go back to the source (in Query Settings) and expand Entity as well

Here is a picture:

Is there a technique to expand both of Individual and Entity at once?



Second Difficulty - Expand All Columns at once

Then, I need to take each column one by one and have them expanded.

Is there a technique to expand all columns at once?

Third Difficulty - Expand Tables nested within Cells

There are nested tables within the cells of the expanded columns (in many of them, actually)

• Is there a technique to expand the tables within cells as rows in the big table? Can all of them be expanded at once?

Your help would be very valuable. I cannot get to the bottom of it.

G