multiple conditions in filter stage

hitmanthesilentassasin · Mon Dec 10, 2007 10:02 pm

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

devidotcom · Post by **devidotcom** » Mon Dec 10, 2007 10:12 pm

Is #Var1# is a job parameter?

hitmanthesilentassasin · Mon Dec 10, 2007 10:14 pm

Yes it is

devidotcom · Post by **devidotcom** » Mon Dec 10, 2007 10:56 pm

Check the datatype of Var1 job parameter. Check if it is String.

hitmanthesilentassasin · Mon Dec 10, 2007 11:00 pm

yes it is a string.

devidotcom · Post by **devidotcom** » Tue Dec 11, 2007 12:39 am

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..

Maveric · Post by **Maveric** » Tue Dec 11, 2007 12:55 am

Why not use a transformer to filter the data? You can give the conditions in the link constraint.

devidotcom · Post by **devidotcom** » Tue Dec 11, 2007 1:21 am

Yes thats right...

ray.wurlod · Post by **ray.wurlod** » Tue Dec 11, 2007 2:11 am

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.

ds_sai · Post by **ds_sai** » Tue Dec 11, 2007 8:06 am

Hi,

Can u please check whether RCP is enabled or not?

Cheers
ds_sai