topic Re: Remove test records from a table. in QlikView

Remove test records from a table.

Mon, 30 Jul 2012 12:09:29 GMT

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

Re: Remove test records from a table.

Nicole-Smith — Mon, 30 Jul 2012 12:28:31 GMT

Tree_Service:

LOAD *

FROM Tree_Service.csv

WHERE Field <> 'NOT DETERMINED';

Re: Remove test records from a table.

Mon, 30 Jul 2012 12:49:21 GMT

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

Re: Remove test records from a table.

Nicole-Smith — Mon, 30 Jul 2012 12:59:59 GMT

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';

Re: Remove test records from a table.

Mon, 30 Jul 2012 13:25:28 GMT

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