Multiple Inputs for an Iterative Macro

[AmitojSingh]

Hi there, I am trying to do the following

1. Have a specific value date which I need to check against a list of dates (holiday dates)

2. I do a join between these 2 datesets and if i find a match, I would like to increment the date by 1

3. Repeat steps 1 and 2 until my Value date is not same as the list of dates

I have attached the code, I am trying to understand if we can have 2 seperate inputs in a Iterative Macro

Many Thanks for your help

Amitoj

[apathetichell]

hmmmm.... so with an iterative macro - only one input is the iterating input and it must have the same fields between the initial macro input and the loop. This is controlled via interface designer. If you need help with this - you should try the awesome video on macros under the learn tab. So you can have two macro inputs, or however many you want inputs/macro inputs but only one that iterates - the other is static...

So for example - your loop includes two fields but your original input includes one field. if you have your interface designer set to allow multiple schema this will probably grow a column with each iteration.

Your loop is formatted as a date but your original is in the dd/mm/yyyy stringtype. That wont' work. and if it did you'd have a problem because your first step is to convert to datetime which won't work because on the second iteration you'll be bringing in a datetime.

[danilang]

Hi @AmitojSingh 

What output are you looking for?  Do you want the numbers of time that the [Value Date] matches a holiday?

Dan