Replace value in tag elements of XML

[Banu]

I have a XML file with the below tag elements. I have to replace the Address line1,city,Postalcode tag elements with the list  attached in the excel sheet and construct the xml file for each address.

<rows>
<row>
<AddressLine1>3101 SW Troon Ln</AddressLine1>
<City>Bentonville</City>
<PostalCode>72712</PostalCode>
<Country>USA</Country>
<user_fields>
<user_field>
<name>AddressCode</name>
<value>1</value>
</user_field>
</user_fields>
</row>
</rows>

[patrick_digan · Accepted solution]

Hi @Banu, I've attached the way I would do it. Let me know if you have more requirements or if your situation isn't quite solved with the attached. I just brought the excel file with addreses into the workflow and used a formula tool to build the xml needed. 

Patrick Digan

[Banu]

Thanks Patrick. It works!!!