App Development

[alsellaro]

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"

[alsellaro]

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

Thanks a lot.