topic Exclude data that contains (C) in QlikView

Exclude data that contains (C)

Sunil_Kenth — Fri, 30 Dec 2011 11:51:12 GMT

Hi,

I would like to exclude data from my data set through the load script where the 'StoreName' contains '(C)' at the beggining.

How can i do this?

Thanks,

Sunil

SunilChauhan — Fri, 30 Dec 2011 11:53:33 GMT

try this

Load

from path where left(StoreName,1)<>'C';

hope this helps

Sunil_Kenth — Fri, 30 Dec 2011 12:24:10 GMT

Thanks Sunil, this worked:

where

left(Store_Desc,3)<>'(C)'

and

left(Store_Desc,3)<>'(c)'

Thanks,

Sunil

SunilChauhan — Fri, 30 Dec 2011 13:00:17 GMT

no need to write two times

where

left(upper(Store_Desc),3)<>'(C)';

this will also server the purpose.