Remove test records from a table.

[#1]

I have the following problem:

I load a table from Excel, called "Tree_Service" including other tables.
During the testphase of this application, testrecords are added.
These all contain text like "NOT DETERMINED" how can i remove these records, during the loadphase.

Sincerely,

Frans

[Nicole-Smith]

Tree_Service:

LOAD *

FROM Tree_Service.csv

WHERE Field <> 'NOT DETERMINED';

[#3]

Nicole, thanks for the information, I made ​​the following,

Directory;

LOAD

Day,

CI,

Dienstenboom    

FROM

Dagrapport.xlsx

(ooxml, embedded labels, table is Dagrapport) Where Dienstenboom <> 'NIET BEPAALD';

QV shows still the records "NIET BEPAALD"

Am I doing something wrong?

Sincerely,

Frans

[Nicole-Smith]

That should be correct...

Is it possible that you might have trailing spaces after the "NIET BEPAALD"?  If so, you may want to try:

Directory;

LOAD

Day,

CI,

rtrim(Dienstenboom) as Dienstenboom

FROM

Dagrapport.xlsx

(ooxml, embedded labels, table is Dagrapport) Where Dienstenboom <> 'NIET BEPAALD';

[#5 · Accepted solution]

Nicole,

There was another phrase called ''NIET BEPAALD-TIJDELIJK''  I removed it by doing

'Where Dienstenboom <> 'NIET BEPAALD' and Dienstenboom <> 'NIET BEPAALD-TIJDELIJK';'

Now it works.

Thanks