How to avoid loading data according to the value of a field?

[Anonymous]

Hello

I need to load data on a Table chart ignoring any record that has a specific value for one of the fields. Is there an elegant way of doing it?

The field name is Status. I want to load and display all records on the Table chart, except for records whose Status = "X".

It seems a rather basic question, but I didn't manage to find an answer anywhere.
Thanks

[rachel_delany · Accepted solution]

Have you tried using a where condition in the load script?

E.g.

LOAD *

FROM data

WHERE Status <> "X"

[Anonymous]

It worked with where [status] <> ('X');

Thanks a lot.