Filter in script

[#1]

Hi,

In my dataset, I have a large number of carriers, which I load in my script under the field name 'Carrier'. However, I am only interested in the data of two carriers, namely 'Malcolms' and 'Owens'. I know I can filter them out in my graphs with set analysis, but how can I already filter them out in my script?

[datanibbler · Accepted solution]

Hi Niek,

try using a WHERE clause:

LOAD

   ...

   ...

FROM ...

WHERE (carrier_name = 'Malcoms'

OR          carrier_name = 'Owens')

;

HTH

Best regards,

DataNibbler

[#3]

Yes, that worked. Thank you

[#4]

You can Try with Match function as we like below:

LOAD *

FROM SOURCE.qvd (qvd)

WHERE MATCH(Carrier ,'Malcoms','Owens') ;