community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Replace value in tag elements of XML

Meteoroid

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>

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

Meteoroid

Thanks Patrick. It works!!!

Labels