Set analysis filtering Issue ?

[veeranj]

Hi All ,

I have data as below :

If Desc is null,i am counting

load cust,if(len(trim(desc))=0,null(),desc) as desc;

LOAD * INLINE [

    cust,desc

    c1,

    c2

];

I have to count the below expression :

Count({<desc={'pureatgrp'}>}cust) -- it is giving output as 2, but there are no desc having desc='pureatgrp' .

Not sure of why it is behaving like this .

Thanks,

Veera

[tresB]

Please don't create duplicate threads. This is being discussed here: Re: Set analysis filtering Issue ?