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!