Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Replace value in tag elements of XML


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.


<AddressLine1>3101 SW Troon Ln</AddressLine1>

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


Thanks Patrick. It works!!!