Variables or parameters

kbrummert

Is there a variable or parameter object whose value I can set using a drop-down or some other interface while running an application?

I was able to do a workaround using an update value object, but this does not appear to be available across the workflow, as a user variable would be in MS Integration Services.  Is there such an equivalent in Alteryx?

vkarthik21

In the 'Workflow Configuration' tab, go to 'Workflow'. Here you would find 'Constants'. Here is where you can declare user defined variables which is similar to Variables in SSIS. This value can be accessed across the whole workflow.

The catch here is that unlike SSIS, you can't change this variable value externally via a config file etc. It needs to be done manually every single time. I know, it is not 'Configuraiton' that you would expect. 

if you still want to achieve this, what I would suggest is to maintain a flat file of variables and configuration values and use an 'Input Tool' to get this into your workflow. You would need to somehow have these config values added as extra details on to your input data and then start using them. It's not an ideal solution, it would be messy but it would still ensure you have a way of making the configuration environment specific and dynamic without having to open Alteryx.