Local Variable

[N0SHEEN]

Hi ,

Can I create a local variable that later can be used to filter values multiple time. e.g. var=26, that var can be used multiple time in a work flow to  filter values (that way I don;t have to change values manually multiple time in a work flow. Also every week I needs to update that var in my workflow. How can I go about this

Thanks,

[ChrisTX · Accepted solution]

Click on a blank area of your workflow then under Workflow Configuration click the tab for Workflow.

Add a constant with type User.  If the value is numeric, check the box under the # column.  The value will be read-only; the value cannot be updated by the workflow.

To use the value in a formula or filter, use the syntax [User.ConstantName]

 

 

Chris

[N0SHEEN]

Thanks Chris , I just figured that out... 🙂

[MelisaCapri]

Thanks for posting this. Is there a way to use a stored path variable in the Connect a File or Database field of an Input Data object?

I stored the path as a user variable

vSourceFolder = "C:\Users\mc13144\Documents\Development\Source\"

, but I am unclear how to use it as part of the path. I tired the following, both with and without the quotes

[User.vSourceFolder] + Static\EECrosswalk.xlsx

[User.vSourceFolder] + "Static\EECrosswalk.xlsx"

[patrick_digan]

@MelisaCapri You can reference shortcuts. Your input tool would have something like this:

%User.vSourceFolder%Static\EEcrosswalk.xlsx

See the bottom of the help page here for documentation: https://help.alteryx.com/current/designer/constants

---

@MelisaCapri wrote:

Thanks for posting this. Is there a way to use a stored path variable in the Connect a File or Database field of an Input Data object?

I stored the path as a user variable

vSourceFolder = "C:\Users\mc13144\Documents\Development\Source\"

, but I am unclear how to use it as part of the path. I tired the following, both with and without the quotes

[User.vSourceFolder] + Static\EECrosswalk.xlsx

[User.vSourceFolder] + "Static\EECrosswalk.xlsx"

---