Hi Everyone,
I'm a week into using Alteryx and have built a workflow which takes an excel input file, filters the data for 3 specific scenarios and then populates a pre-prepared output template file, overwriting the sheets already in the template file. I've attached a screen grab of the workflow for reference.
All of the output files relate to different sheets within the same excel workbook, and when I come to use this in a live environment I will need to re-link the output file to a new template workbook, located in a different folder. Currently, I have to click on each output file and then select the new location for the template to be populated (the sheet name will stay the same). Is there any way for me to update the location for all of these outputs at the same time, rather then individually linking them?
Thanks in advance
Kind regards
Andy
Solved! Go to Solution.
Hi @andrew_bacchus ,
what about Find Replace?
You'll find the option in menu:
or using <Ctrl> + <F> / <Ctrl> + <H>
Give it a try an let me know if it works for you.
Best,
Roland
That works. Thanks Roland