multiple conditions in filter stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am
multiple conditions in filter stage
Hi,
I am trying to define conditions like the one's below.
Col1="XXXX" and #Var1#="YYY"
where var1 has got the value YYY, for which i am getting the error
Expected YYY in the schema.
can you help me define this conditions?
Thanks
I am trying to define conditions like the one's below.
Col1="XXXX" and #Var1#="YYY"
where var1 has got the value YYY, for which i am getting the error
Expected YYY in the schema.
can you help me define this conditions?
Thanks
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
Hi I happened to read the manual for filter stage... please check below.
The operation of the filter stage is governed by the expressions you set in the Where property on the Properties Tab. You can use the following elements to specify the expressions:
Input columns.
Requirements involving the contents of the input columns.
Optional constants to be used in comparisons.
The Boolean operators AND and OR to combine requirements
So according to it we cannot use job parameter to compare..
The operation of the filter stage is governed by the expressions you set in the Where property on the Properties Tab. You can use the following elements to specify the expressions:
Input columns.
Requirements involving the contents of the input columns.
Optional constants to be used in comparisons.
The Boolean operators AND and OR to combine requirements
So according to it we cannot use job parameter to compare..
-
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can certainly use job parameters in simple conditions in a Filter stage - I have not checked a compound condition (one with And or Or) but can not imagine there would be any difficulty. However, it can be finicky with quote characters - try using single quotes rather than double quotes, for both dates and strings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.