Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Looking for a way to Input results into a premade word document.

JohnGagnon2000
6 - Meteoroid

There is a standardized word document with many sections to fill. I would like to use this doc as a template as I cannot remake all the features within the reporting tools. Is there a way to output to specific areas in a word document and leave the rest alone? I see results pointing to the report and layout tools, but I cannot think of a way to make that work for me. Suggestions and examples would be great!

 

If I could import a template for the layout tool to recognize and copy that would be ok, but to remake the entire report would be not worth the effort and I am unsure how to use the formatting tool to precisely recreate the document in a way to not cause errors.

 

Items to edit:

Header

Footer

Swapping Characters/text

Filling named text boxes

12 REPLIES 12
OTrieger
14 - Magnetar

\0 means no delimiter, back slash zero. I do not want to have a delimiter as XML does not have one.
Do not worry about the length also long as you set it to 254000000, it will be fine after the Parse tool

JohnGagnon2000
6 - Meteoroid

My find and replace seems to have turned field 1 to zero...

 

[Field_1] = Replace([Field_1], "<", "~<")

 

The parse tool just provides the same results too. Weird. I see yours also shows a truncated error box so not sure where this goes wrong. Seems like a great idea.

OTrieger
14 - Magnetar

@JohnGagnon2000 
Do not worry about truncated error, it is only indicating that you will not see all the data, Alteryx does not remove any data.

Your formula is wrong, it should be only Replace([Field_1], "<", "~<")

Labels
Top Solution Authors