Forum Discussion

MatjoCol's avatar
MatjoCol
Frequent Visitor
6 years ago
Solved

Missing column from nested XML generates error when trying Table.ExpandTableColumn

Hi, 

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.

 

Best regards,
Mattias