Excel to XML

[KamenRider]

Hi guys,

I seeking you assistance if you have any sample how we can convert excel to xml. I tried searching but I can't find one I can understand.

Hoping for your kind assistance on this matter.

thanks,

Kamen

[apathetichell]

@KamenRider @DavidSkaife - sorry if I wasn't clear - @KamenRider - you posted the error on Tuesday. The problem is that <Addresses></Addresses> which you posted in your XML example on Tuesday is WRONG. This is tagging with nothing inside. The actual coding is for for an overall group which the loans are a part of.

The format must be:

<Addresses/>

Loan body...

</Loans>

</Addresses>

</Root>

<Addresses/> tells the ingestion system that this is an <Addresses> entry which the rest of the XML is part of.

[DavidSkaife]

@apathetichell ahhh oops, my bad!

So the output now looks like this at the top:

and this at the bottom:

Updated workflow and output attached

EDIT: Two versions now attached. v2 has <Addresses/> whereas v3 (and output3) has <Addresses>