Make a filter in the script after load a xsl file

[oscargm_bi]

Hi everyone,

I'm triying to make a filter in the Data Loader, for example

Column: SERVICE, this column bring me a lot name of services provides to a company, but I do not want that certainly services count in the app that I'm developing and the services are: AMBULANCE and PIMP.

How can I do the filter? any example?

Thanks a lot,

Regards,

Oscar,

[dplr-rn]

You will have to use data load editor to filter the data

[jonathandienst · Accepted solution]

If you want to exclude AMBULANCE and PIMP, add a Where clause to the load:

...
Where Match(SERVICE, 'AMBULANCE', 'PIMP') = 0;

[MindaugasBacius]

If you wish your data contains only services AMBULANCE and PIMP the load script should look like this:
Table_name:
Load *
From
Where Match(SERVICE, 'AMBULANCE', 'PIMP')
;