XML Data - Table Expand Columns with empty table or containig null

[staceytwang]

In my XML Data file, it contains multiple parent nods and mutliple child nodes (credit card transactions).  Depending on data, sometimes there is no data in some nods (could be parent, could be child).  How do I expand Table.Columns in this situation so I can load 100% of data?

Here is a screenshot of what I am working with.XML containing null or table

[Anonymous · Accepted solution]

HI @staceytwang,

Maybe you can take a look at following link about use custom function to expand all nested tables at same time.(provided by @MarcelBeug)

How to expand all nested tables at once table.expandtablecolumn

Regards,

Xiaoxin Sheng