I have an xml document which I have imported into a data mapper. However I am trying to get a single structure from this but am not being very successful. Each new records starts on the document tag. Field name is in the following field:-
That value of that field is in the following field:-
This can be repeated a few times. How would I go about getting a single record out of this please?
I have put a sample of the XML file below:-
Thanks In Advance!
302 1 auto RA_SURNAME Sample RA_TITLE Mr RA_SURNAME Sample RA_TITLE Mr