topic Remove not needed data in script in QlikView

Remove not needed data in script

Mon, 05 Nov 2012 16:35:04 GMT

HI,

I have a field called Events which has 10 types of events (E1,E2,....,E10).

There are only 5 events which I am interested in. How can I remove E6,...,E10 events in Script?

Thanks

Re: Remove not needed data in script

swuehl — Mon, 05 Nov 2012 16:38:21 GMT

Use a where clause in your load with an appropriate condition:

... where Match(Events,'E1','E2','E3','E4','E5');

Re: Remove not needed data in script

Mon, 05 Nov 2012 17:20:06 GMT

Thanks but I tried to apply it and it says "Garbage after statement".

Any idea what am I typing wrong?

LOAD [Segment Name],

[Event category],

[Event action],

[Week Commencing],

[Total events]

where Match([Event category],'Newsletter')

FROM

$(ExtractPath)\GA_Events.QVD(qvd);

Re: Remove not needed data in script

MayilVahanan — Mon, 05 Nov 2012 17:21:21 GMT

HI

Try like this

LOAD [Segment Name],

[Event category],

[Event action],

[Week Commencing],

[Total events]

FROM

$(ExtractPath)\GA_Events.QVD(qvd) where Match([Event category],'Newsletter');

Re: Remove not needed data in script

Mon, 05 Nov 2012 17:28:36 GMT

It works thanks a lot.