Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Excel to XML

KamenRider
11 - Bolide

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

41 REPLIES 41
apathetichell
19 - Altair

@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
13 - Pulsar

@apathetichell ahhh oops, my bad!

 

So the output now looks like this at the top:

DavidSkaife_0-1669989725546.png

 

and this at the bottom:

DavidSkaife_1-1669989747512.png

 

Updated workflow and output attached

 

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

 

Labels