Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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