How to stop the "Test Service" coming onto the table.

[Anonymous]

Hi,

I have data coming from the database which has got both Live services and Test service.

How Can I stop the data coming onto the Table.

This is the code I have been using but still showing the Test data.

services:

LOAD id AS service_id,

   name AS service_name,

SQL SELECT id,

    name

FROM "myhealth_production"."public".services;

Any help pls.

[buzzy996]

u can try with simply if expression,if ur fieldname='testservice',null(),fieldname;

[adamdavi3s · Accepted solution]

LOAD id AS service_id,

   name AS service_name,

SQL SELECT id,

    name

FROM "myhealth_production"."public".services

WHERE name not like '%test%';

???

[Anonymous]

nope it is still getting Test.

[adamdavi3s]

Is it coming in elsewhere in your data model then?

[Anonymous]

Thanks Adam.

It worked now.

much appreiciated.

[adamdavi3s]

Excellent, glad you are sorted