Using Constant to define input file

Question

I have 5 files saved in a 'Reference' folder, with set file names - say a.xlsx, b.xlsx, c.xlsx, d.xlsx and e.xlsx.

I'm after setting a User Constant value where the user can input their folder directory and that value is used when inputting the Excel data.

EG setting "C:\Documents\Reference" as the folder, and then using a Formula to create "C:\Documents\Reference\a.xlsx" for the first file.

This is to simplify setting the file name in the Input Data tools.

There didn't seem the ability to pass a field into the Input section of either an Input Data tool, Dynamic Input tool or a Directory tool.

Does anyone have any ideas on how to achieve this?

Many thanks.

tomgilbert · Accepted Answer

Thanks, however the issue is with the 'Input Data Source Template' box requiring an actual file, even if it is subsequently ignored by passing in a new file path.

This was one option:

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Dynamic-Input-Using-dummy-input-file-for-source-template-Errors/m-p/526778#M5684

I created a simple workflow to get round this - creating a text input to save an Excel file in the %temp% folder, to then use this file in the 'Input Data Source Template' box as a 'dummy' file and changing the file path via a formula tool and bringing in the User Constant then.