Remove not needed data in script

[#1]

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

[swuehl]

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

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

[#3]

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);

[MayilVahanan · Accepted solution]

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');

[#5]

It works thanks a lot.