Iterative Add one until the date cannot be mapped by join

[bowangtw]

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:

My input table: 

My mapping table:

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!