Create Variables Similar to SQL Local variables

tjamal1

Can we create a variable in Alteryx like an SQL local variable that can be created using set statement ?

For example

Set @last_end_dt = isnull((Select Max(end_dt) From Customer), '2016-03-31')

and this variable has usage in another formula

set @end_year = (select fiscalyear from dimDate where FullDateAlternateKey = DATEADD(DAY,28,@last_end_dt))

I want to create these variables so that i can use them in any part of the workflow 

Is there any way to do it ?

danilang

Hi @tjamal1 

There is no equivalent of dynamic local variables in Alteryx.  The closest thing is user constants, but they are static once set and cannot be changed in the workflow.

The way this is usually handled in Alteryx is to use a tool to create a new column of data in your work flow using a formula tool if you can calculate the value inline or perhaps a summary tool followed by an append fields to create summarized values.

Dan