nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

While Loop in Alteryx (SQL)

tjamal1

I am trying to replicate a SP which have a while loop that checks specific condition

@end_date <= Cast(Cast(Max_Txn_date as varchar(10)) as date

Begin
@start_date as 'start_dt
,end_date as 'end_dt'....

...

Is there anyway i can write or implement that same loop logic in Alteryx Designer

Iterative Macro

Accepted answers

GiuseppeC

@tjamal1,

editing the original post with the actual solution, as shared by @JoeS here.

"Due to the nature of In-DB tools creating a script and processing it database side, it's not possible to then create batch or iterative macros whereby the data has an impact on the flow itself (AKA how many batches, potentially depending on control parameters changing the configuration each time)."