Excluding a value from a table

[Anonymous]

Hello,

I'm loading a table called status, which contains the values: Sold, In Stock, Reserved, Unknown.

I'm wondering if it's somehow possible to exclude the value 'Unknown' from the load so that for all graphs, charts or filters I have the value is not even listed.

Can someone help me here?

Cheers

spijatida

[robert_mika]

use where

t1:

load * inline

[Status,Value

Sold, 20

In Stock,30

Reserved,30

Unknown,20

];

t2:

load Status as stat,

Value as val

resident t1

where Status<>'Unknown';

drop table t1;

or if you are loading data from table

Directory;

LOAD Status,

     Value

FROM

Book2.xlsx

(ooxml, embedded labels, table is Tab1)

where Status<>'Unknown';