CODEWITHSUNDEEP
alteryx
ravi teja pandilla
ravi teja pandilla

Reputation: 67

using the parameters in Alteryx workflows

I am fairly new to the Alteryx. I would like to create a process/workflow in Alteryx to import a file from a specified location but that should be controlled by the input parameters.

Kindly help me in this.

Thanks, RTJ

Upvotes: 0

Views: 1096

Answers (2)

Stu
Stu

Reputation: 41

In the developer tool category, you'll find the Dynamic Input tool. This works much like the standard Input Data tool, but can take records in to modify the data it collects. https://help.alteryx.com/2018.2/DynamicInput.htm

It sounds like you have files in a standard location, but want to be able to dynamically select the ones to load. Let's say you have a collection of sales files in the format "Sales_20190718.csv" but want to only get sales information for certain dates as specified in your workflow. You can point your Dynamic Input tool to the Sales_20190718.csv, and have it replace the "20190718" part with whatever input you gave to the tool before querying the information.

You could get a similar result by using wildcards in a basic Input Data tool by pulling data from "Sales_*", and ticking the "Output File Name as Field" box. This would load all your sales data (which could take some time) but then you could filter to the relevant files using the new FileName field.

Upvotes: 1

Degan
Degan

Reputation: 989

You can connect an Interface Tool:File Browse via an Interface Tool:Action to change the file selected to an In/Out:Input Data:

enter image description here

You will then want to run the workflow using the Run As Analytic App:

enter image description here

Upvotes: 1

Related Questions