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 ?
Solved! Go to Solution.
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
So that means if i want compare that specific value to the column of another table , I Should append this specific field to that table ?