Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Niek,
try using a WHERE clause:
LOAD
...
...
FROM ...
WHERE (carrier_name = 'Malcoms'
OR carrier_name = 'Owens')
;
HTH
Best regards,
DataNibbler
Hi Niek,
try using a WHERE clause:
LOAD
...
...
FROM ...
WHERE (carrier_name = 'Malcoms'
OR carrier_name = 'Owens')
;
HTH
Best regards,
DataNibbler
Yes, that worked. Thank you
You can Try with Match function as we like below:
LOAD *
FROM SOURCE.qvd (qvd)
WHERE MATCH(Carrier ,'Malcoms','Owens') ;