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