Excel data to xml conversion - Need help

Question

Hi, I have below excel records and i want convert this records into define xml format :- Input Data :- CustomerIdAccountNumberCustomerBankIdentificationTypeOpneingDate1101ID001Savings8/1/20191102ID001Current8/23/20191103ID001Savings9/17/20192201ID002Savings1/4/20202202ID002Savings2/7/20203301ID003Savings3/19/20213302ID003Savings3/19/20213303ID003Savings3/19/20213304ID003Savings3/19/2021 Expected output : "Savings" 2019-08-01 "Current" 2019-08-23 "Current" 2019-07-17 "Savings" 2020-01-04 "Current" 2019-02-07 Please assist me how i can create above xml format using alteryx

alt_tush · Answer

Hi apathetichell,

Yes, there is no out of box solution for this.

Also yes its a semi-structured xml so i have to do some work around or implement some logic in workflow.

I am able to create the workflow and generate the xml what i expected :)

Thank you for your assistance :)

apathetichell · Answer

hi! Sorry - but unless you can specify what you are converting your xml for and happen to find someone who can match your schema - there won't be an out of the box solution - you have a fairly specific parent/child syntax - and reading through that thread will probably help you get to what you are trying to do.

Keep in mind that you are basically taking a row/column formatted xml (Alteryx) and turning into a semi-structured xml (nested parent/child schema) so it takes some work.

alt_tush · Answer

Hi Jay-RDC,

There are so many posts in given link.. do you where i can get exact solution? Any link?

I want to create the xml based on the format i mentioned. It is not simply convert the excel data into xml.

Thank you for reply :)