Missing column from nested XML generates error when trying Table.ExpandTableColumn
I am trying to get data from an XML which has some nested fields. The problem I am encountering is that sometimes fields are missing from the XML so when I try to Table.ExpandTableColumn I get an error. It would have been nice if you could use MissingField.Ignore to handle the missing columns but it does not work.
Is there a way to work around this? I know the name of all columns that potentially be present in the XML if that is any help.