Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
skh
Contributor

Exclude data that contains (C)

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

Tags (1)
1 Solution

Accepted Solutions
skh
Contributor

Exclude data that contains (C)

Thanks Sunil,  this worked:

where

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

and

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

Thanks,

Sunil

3 Replies
chauhans85
Esteemed Contributor

Exclude data that contains (C)

try this

Load

f1

f2

.

.

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

hope this helps

skh
Contributor

Exclude data that contains (C)

Thanks Sunil,  this worked:

where

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

and

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

Thanks,

Sunil

chauhans85
Esteemed Contributor

Exclude data that contains (C)

no need to write two times

where

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

this will also server the purpose.

Community Browser