Filter stage not removing nulls

times29 · Post by **times29** » Fri Oct 19, 2012 1:19 pm

Hi,
i am doing this in filter stage payr_vblnr is not null and i am still getting nulls and i am doing trim in transformer as i can't do trim in filter stage

But when i run sql in oracle doing where trim(payr_vblnr) is not null it works gives me desire result

I did try putting constraint in transformer doing IsNotnull it don't work.

Please tell me what can i do in filter then

chulett · Post by **chulett** » Fri Oct 19, 2012 1:24 pm

That would imply they're not nulls but rather empty strings. It works in Oracle because Oracle treats them as equivalent but DS does not. Try filtering for empty strings ('') or both and see if that works.

times29 · Post by **times29** » Fri Oct 19, 2012 2:03 pm

i did try payr_vblnr is not null or payr_vblnr <>' ' but same result

srinivas.g · Post by **srinivas.g** » Fri Oct 19, 2012 2:39 pm

Use below constraint in transformer

Not(isnull(<<column_name>>) and len(<<column_name>>)<>0

chulett · Post by **chulett** » Fri Oct 19, 2012 3:58 pm

times29 wrote:i did try payr_vblnr is not null or payr_vblnr <>' ' but same result

Unless that's a typo, there's a space between those two quotes in what you posted so that (a space) is what it is attempting to filter. Just use two quotes to represent the empty string.