Need information on how to do a Loop process in Alteryx.

[GeorgeLevesque]

Hi,

Need information on how to do a Loop process in Alteryx.

I have 24  occurrances of a field for both Start_date_1 and Stop_date_1      Start_data_2, Stop_date2, and so on until I reach 24.

I am unsure how to code this in Alteryx but would like to code it so it used an amper variable if possible 

for similar code I have in another application below but do something similar in Alteryx.

todays_date   (need a variable set to store todays actual date)

set &a = 25

loop

set &a = & -1

if &a = 0 go to out

if start_date_&a less than todays date then take that record

If stop_date_&a greated than todays date then take that record

else go to loop for next record and only take the record that matched the above If statements.

__________

Can someone please help me to provide me with either the actual sql code which I can cut and paste into an input tool as sql code or is there an tool that you can provide that will do this process.

Thank you,

George Levesque@Citizensbank.com

[acarter881]

Hello, @GeorgeLevesque.

Can you provide a sample input and a sample output?

From your description, it sounds like a while loop, which would mean you can use an iterative macro in Designer to achieve the result.

Still, it would be best to show a sample so the process is clearer.

Here's a video about iterative macros: https://www.youtube.com/watch?v=xExR3-rmcDc