I have a job parameter that is used to as an array/list to store a random number of variables. As an example it can be a three digit code for a list of all countries. I need to use the job parameter in a filter stage to filter the records. I am looking for a function similar to the 'IN' condition that can be used in SQL. It looks like using 'IN' as a predicate in the filter stage is now possible. Any suggestions on implementing the above logic would be of great help.
Thanks.
IN condtion in Filter stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Premium Member
- Posts: 79
- Joined: Thu Mar 22, 2007 4:58 pm
- Location: USA
When it is populated should make no difference. Assign the list to the parameter that you want to use, and make sure it is in the right format. There is nothing that would change the evaluation based on when the list is generated (static vs dynamic).
Jack Thornton
----------------
Spectacular achievement is always preceded by spectacular preparation - Robert H. Schuller
----------------
Spectacular achievement is always preceded by spectacular preparation - Robert H. Schuller