We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Change string in XML child and save XML file

Flo_G
7 - Meteor

I have an XML file from a PPT presentation, I'd like to update some keywords within it and save the file.

 

"slide2.xml" is the base file.

a:t is the target child within the file.

 

The values should be replaced with the corresponding entry from a database, and each line should produce a separate xml file (e.g. line 2 produces slide2.xml, line 3 produces slide3.xml, etc).

 

dummyData.csv is an example database with two entries.

 

I have managed to:

  • transpose the database information; there's a bunch of data transformation between database input and transpose, not relevant to the issue - the dummyData mirrors the data output after transformation
  • extract the a:t information with the Input Data tool and
  • replace the values.

What I'm lost with is how to output the xml file back, and how to change this to a loop so it goes through all the records in the dabase:

Flo_G_0-1643360017295.png

 

 

Thank you for your help!

0 REPLIES 0
Labels
Top Solution Authors