Page 1 of 1
multiple conditions in filter stage
Posted: Mon Dec 10, 2007 10:02 pm
by hitmanthesilentassasin
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
Posted: Mon Dec 10, 2007 10:12 pm
by devidotcom
Is #Var1# is a job parameter?
Posted: Mon Dec 10, 2007 10:14 pm
by hitmanthesilentassasin
Yes it is
Posted: Mon Dec 10, 2007 10:56 pm
by devidotcom
Check the datatype of Var1 job parameter. Check if it is String.
Posted: Mon Dec 10, 2007 11:00 pm
by hitmanthesilentassasin
yes it is a string.
Posted: Tue Dec 11, 2007 12:39 am
by devidotcom
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..
Posted: Tue Dec 11, 2007 12:55 am
by Maveric
Why not use a transformer to filter the data? You can give the conditions in the link constraint.
Posted: Tue Dec 11, 2007 1:21 am
by devidotcom
Yes thats right...
Posted: Tue Dec 11, 2007 2:11 am
by ray.wurlod
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.
Posted: Tue Dec 11, 2007 8:06 am
by ds_sai
Hi,
Can u please check whether RCP is enabled or not?
Cheers
ds_sai