topic Re: Use connection string in a expression in Alteryx Designer Desktop Discussions

Use connection string in a expression

rbarron — Mon, 20 May 2019 07:56:37 GMT

Is there a way to check or store the connection string in a variable within a workflow to make it possible to include it in an IF/ELSE statement?

My workflow needs to check whether I'm in the DEV/UAT/PROD Database and return an expression based on it.

Re: Use connection string in a expression

LukeM — Mon, 20 May 2019 08:18:59 GMT

Hi @rbarron ,

The way you can achieve this is by using the user-defined constants in the Workflow Configuration window. You can create a constant which would be all (or part) of your connection string. This can then be called and used in formula tools or connections in the workflow. The benefit of this is that you can then edit the connection string in one place and this will propagate throughout the workflow.

The Configuration Window can be foun by clicking on the canvas white space and then on the Workflow tab on the left.

Hope this helps.

Luke

Re: Use connection string in a expression

rbarron — Wed, 22 May 2019 01:05:45 GMT

Thanks @LukeM!

Its now working.