Forum Discussion
XML Data - Table Expand Columns with empty table or containig null
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
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
1 Reply
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