Originally posted by: repanzer1
I don't believe you can do it in the IFD settings, but you can do it.
Build a map that will be used to run the map you want ran every 3 weeks on a Monday. It will have one input file which contains one numeric, integer field. Point that input card to a file that contains just a 1. Then either build 3 output cards with one field each, or, one output card with 3 fields.
In the first field, determine if it's Monday by using the CURRENTDATE function to return what day it is, and using the date formats in the function guide, which will show you how to return 'Monday' or 'Tuesday', etc, based on what the current day is.
In the next field you say, If Output field 1 = "Monday" and the InputField from the input card = 3, RUN(YOURMAP).
In the last field, you put this statement;
=IF(InputField=3, GETANDSET(InputField, 1,1), GETANDSET(InputField,InputField + 1,2))
That statment will add 1 to the value in the input file if that value is not equal to 3. If that value is equal to 3, it resets it back to 1.
This will run the map every third Monday. Set map you just created to run every day and deploy the system.
There are 10 types of people in this world. Those who understand binary and those who don't.
#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender#DataExchange