Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';