XML tag replacement till end

[Arg0n11]

Hi All,

So I am running into a bit of an issue that I need assistance with. I am creating a workflow that takes input of a pdf version of a specific report and pulls all the acronyms out to build a glossary within powerpoint. I have completed the functionality of pulling out the acronyms into a table but now I am figuring out how to get these into a powerpoint template file.

I started using a template powerpoint with XML tags already set up and it works great, except that once this workflow is used by my target audience, there is no way to know how many acronyms would ultimately need to be replaced in the template. The xml file is set up with space for 200 lines / tags, with should never be exceeded.

My workflow is currently using a formula tool like the below to replace the tags but is there a way to make Alteryx know how many tags to replace and stop the formula tool once it reaches that number (Like somehow using the multi-field formula)? At the moment, if the input is 100 tags that need to be replaced and my formula tool has 200 formulas, then it gives an error.

[atcodedog05]

Hi @Arg0n11 ,

Can you attach the workflow so that we can help you better.

[Arg0n11]

See attached. 

The "Template redacted" has space for quite a few XML tags. However the excel input only has 2 terms and definitions. I want to be able to input both into the template, and the workflow would recognize that there is not more than 2 terms and stop inputting. In its current form, my error on the formula tool is due to there not being a third term to add. And in it's final form this would be hundreds of terms

[vizAlter · Accepted solution]

Hi @Arg0n11 — Try this solution.

1st I have changed the layout of your Excel template to remove the use of Append tool.

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

[Arg0n11]

Thanks so much! this worked great