Dynamically derive full path of the Input and Output files

Question

In my workflow I would like to specify the path to the input files as: + \Input\Baseline1.xlsx, + \Input\Baseline2.xlsx etc., and would like to provide an option to the user to either input or store the value of the in one of the input files/ static input (e.g., H:\APAC\Alteryx Analysis\2019\, based on how the users have mapped the network drive) Is there a way to do this, without the user have to intervene in each step to provide/ choose the input file path names.

tom_montpool · Accepted Answer

I can think of several possibilities if your goal is to have somewhere to store and edit a constant value that can be used in the workflow. It really depends on where you want the users of the workflow to change the constant.

* Store the value in an external file (like a csv). Easily edited outside Alteryx. Easily accessed by the workflow (Input Data). Add to the data file with Append Fields.
* Store the value in a Text Input tool. Easily edited inside Alteryx. Easily accessed by the workflow. Add to the data file with Append Fields.
* Store the value in a User Constant (found on the Workflow configuration tab). Easily edited inside Alteryx. Easily accessed by the workflow. Add to data file with Formula tool.