Is there a good example for processing data from XML files?
I’m a little lost right now which actions would be the best to clean the data.
After adding the XML there are a lot of empty cells/columns because of the transformation from
hierachical to flat data structure.
For example:
/request
/request/Debtor
/request/Debtor/Name
/request/Debtor/Address
/request/Item
/request/Item/Amount
For all existing items the Debtor related columns are empty.
Is there a way to copy data from debtor rows to fill the rows holding Item information (deeper nodes) ?
Thanks for help,
Jochen