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
Solved! Go to Solution.
\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
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.
@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], "<", "~<")
User | Count |
---|---|
106 | |
85 | |
76 | |
54 | |
40 |