topic How to Remove unused data at script level in QlikView

How to Remove unused data at script level

Mon, 31 Aug 2015 11:50:10 GMT

Hello all,

I have data like this, My requirement is i don't want to load the Zip codes starts with '8' at script level. so How can i filter them.

please guide me.

Thanks

Kalyan

Kushal_Chawda — Mon, 31 Aug 2015 11:53:20 GMT

try,

load *

From Table

where not wildmatch(Zip_codes,'8*')

tresB — Mon, 31 Aug 2015 11:53:59 GMT

Load

Zip_codes

From <> Where Not WildMatch(Zip_codes, '8*');

maxgro — Mon, 31 Aug 2015 11:54:31 GMT

load * inline [

Zip_codes

500012

500001

500018

500002

800001

800015

]

Where

not WildMatch(Zip_codes, '8*')

;

Where

not Zip_codes like '8*';

Mon, 31 Aug 2015 11:55:32 GMT

Thank you