XML Output to create based on no of records available in input file

[Myusrename001]

Team,

This is basic input data that i wanted to convert to xml format based on no of records available on dataset, on below example - we have 2 records.

<?xml version="1.0" encoding="UTF-8"?>
<AccountNo>
<Branch>
<AccountType>

Lets say we have a records lie this showing separately on dataset  

AccountNo - 1234 & 2345
Branch - abc & bcd
AccountType D & C

The output should create like this

<?xml version="1.0" encoding="UTF-8"?>
<AccountNo>1234</AccountNo>
<Branch>abc<\Branch>
<AccountType>D<\AccountType>

------------------------------------------------- (end or space)

<?xml version="1.0" encoding="UTF-8"?>
<AccountNo>2345</AccountNo>
<Branch>bcd<\Branch>
<AccountType>C<\AccountType>

------------------------------------------------- (end or space)

Can anyone guide me please. 

Thanks ! 

[IraWatt · Accepted solution]

Hey @Myusrename001,

I've got a basic workflow which can convert your input to your output:

If you have any questions make sure to ask :)

HTH,

Ira

[Myusrename001]

Thanks so much @ IraWatt 

The solution works perfect.  

[IraWatt]

Awesome ! no worries @Myusrename001