Dynamic Input Location Based on Alteryx Workflow Location

amc1794

Hi Alteryx community

I am looking to input multiple files from a directory, based on the directory being located in the same folder as where the Alteryx workflow is saved. I have been able to get the Dynamic Input to work to input all files within the directory but can't work out how to use Engine.WorkflowDirectory to change the location that the Dynamic Input is pointing to.

To explain my rationale for trying to do this, I need to be able to email send the Alteryx workflow to colleagues without them having to re-point where inputs are looking, so I want to tell them to simply save it into a certain folder.

Any assistance would be greatly appreciated.

LordNeilLord

Hey @amc1794

With the Dynamic Input tool, you cant specify a wildcard import (*.*) you need to be explicit about the filename.

So I built you a quick Dynamic Directory tool, which will first read all of the files within the folder you specified in your formula and then pass those to Dynamic Input to read.

Save the macro to your macros folder and then add it into the workflow

Dependent Directory Location.yxzp