Excel data to xml conversion - Need help

[alt_tush]

Hi,

I have below excel records and i want convert this records into define xml format :-

Input Data :- 

CustomerId	AccountNumber	CustomerBankIdentification	Type	OpneingDate
1	101	ID001	Savings	8/1/2019
1	102	ID001	Current	8/23/2019
1	103	ID001	Savings	9/17/2019
2	201	ID002	Savings	1/4/2020
2	202	ID002	Savings	2/7/2020
3	301	ID003	Savings	3/19/2021
3	302	ID003	Savings	3/19/2021
3	303	ID003	Savings	3/19/2021
3	304	ID003	Savings	3/19/2021

Expected output : 

<Customer CustomerId="1" CustomerBankIdentification = "ID001">
<CustomerActions>
       <AddAction>
            <Accounts>
                <Account AccountNumber = "101">
                      <Type>"Savings"</Type>
                      <OpneingDate>2019-08-01</OpneingDate>
                </Account>
                <Account AccountNumber = "102">
                      <Type>"Current"</Type>
                     <OpneingDate>2019-08-23</OpneingDate>
                 </Account>
                 <Account AccountNumber = "103">
                     <Type>"Current"</Type>
                     <OpneingDate>2019-07-17</OpneingDate>
                </Account>
          </Accounts>
      </AddAction>
</CustomerActions>
</Customer>

<Customer CustomerId="2" CustomerBankIdentification = "ID002">
<CustomerActions>
      <AddAction>
           <Accounts>
                 <Account AccountNumber = "201">
                      <Type>"Savings"</Type>
                      <OpneingDate>2020-01-04</OpneingDate>
                 </Account>
                <Account AccountNumber = "202">
                       <Type>"Current"</Type>
                      <OpneingDate>2019-02-07</OpneingDate>
                </Account>
          </Accounts>
     </AddAction>
<CustomerActions>
</Customer>

Please assist me how i can create above xml format using alteryx

[Jay-RDC]

Hi. This should help. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/XML-Output/td-p/466203

[alt_tush]

 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 :)

[apathetichell]

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]

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 :)