Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Dynamic Input Location Based on Alteryx Workflow Location

Highlighted
Meteoroid

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.

 

Highlighted
Alteryx Certified Partner

Hey @amc1794

 

Can you share your worklfow so far so we can see the setup you are using?

Highlighted
Meteoroid

Hi @LordNeilLord

 

Thanks for replying to me. I have attached a zipped folder, similar to how I would like to be able to send to colleagues - they could then unzip the folder into their Document etc and immediately run the workflow based on whatever files they place in the various folders.


Thanks again.

Highlighted
Alteryx Certified Partner

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

 

 

 

 

Labels