Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Iterative Add one until the date cannot be mapped by join

bowangtw
6 - Meteoroid

Hi there,

 

I have a dataset that shows the ID and class dates, and I have a list of leave dates. 

 

I want to find out when the eligible class dates.

 

The logic is as this:

 

(1) Join two tables by ID and dates

(2) If there is a mapped date, add 1 to the class date

(3) Join two tables by ID and dates again

(4) Continue the process up until there is no mapped class date with leave date

 

Obviously, I want to use Iterative Macro since it is a loop. However, I failed.

My macro looks like this:

Macro_QA.PNG

 

 

My input table: 

Input.PNG

 

My mapping table:

mapping.PNG

 

I didn't know how to set the Macro when the criteria matched (there is no mapping), stop the process.

Any suggestions would be appreciated. Thanks!

0 REPLIES 0
Labels
Top Solution Authors