Dear Alteryx experts, I would like to obtain your professional advice on how to organize the workflows and allow user to run the workflows by a single click of RUN button.
The story is that my team is working on hundreds of sources files. And each file comes with unique format. Therefore, I have 2 designers to work on the multiple workflows that:
(1) reading each source file and generating intermediate result sets or files with consistent layout; (one workflow per one source)
(2) reading the intermediate result sets or files, performing validation and generating the final output for data upload to another application. (one workflow for this process)
However, if we combine (1) and (2) above into a single workflow, the canvas size is overwhelming, and it is totally a nightmare for future maintenance. But if we don't do so, how can user run all the processes with only clicking the RUN button once when we put the workflow(s) in Alteryx server?
Thank you.