Use of "in" in Stage Variables
Posted: Fri Feb 06, 2009 11:50 am
Hello all,
Is there a way to replace "IN" statement without using "OR" multiple times while creating a derivation for a stage variable?
Eq: If I have to use a Job parameter "JobP" which has a value of ('AAA',BBB','CCC','DDD') which I use in my source query, I would like to move it to the Stage variable derivation - I currently use:
In other works how do we implement "IN" in the Stage Variable.
Appreciate any help.
Is there a way to replace "IN" statement without using "OR" multiple times while creating a derivation for a stage variable?
Eq: If I have to use a Job parameter "JobP" which has a value of ('AAA',BBB','CCC','DDD') which I use in my source query, I would like to move it to the Stage variable derivation - I currently use:
Code: Select all
ColumnName.Field = 'AAA' or ColumnName.Field = 'BBB' or ColumnName.Field = 'CCC' or ColumnName.Field = 'DDD'
Appreciate any help.