OL Learn

XML field extraction issue


#1

Please help to advice how to extract value from below XML.
When I map the field into data model, all 3 fields I extracted are having same field name as UDF and the value always capture “ABC SDN BHD”.

<DOCUMENT>
        <UDF name="Insured Name">ABC SDN BHD</UDF>
        <UDF name="NRIC No/B.C/Passport No">1234567890</UDF>
        <UDF name="Registration of Company">123456-V</UDF>
</DOCUMENT>

Thanks.


#2

You probably need a Repeat step which creates a detail table by looping on each UDF and extracting the UDF and the name variables


#3

Eventually, I am able to extract the value from UDF tag base on each attributes (which is name) by using the correct XPath syntax

image