Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i have a table as below
NAME | ID | PRICE | ADRESS |
---|---|---|---|
name 1 | 123456 | 100 | 1 street a |
name 2 | 234567 | 150 | 1 street f |
- | 456792 | 150 | 1 street d |
name 3 | 654987 | 0 | 1 street v |
- | 321987 | 50 | 1 street b |
I would like to have the following table
NAME | ID | PRICE | ADRESS |
---|---|---|---|
- | 456792 | 150 | 1 street d |
- | 321987 | 50 | 1 street b |
I would like to create an expression to isolate the null in NAME in order to identify them in a table.
I was thinking first of using the Enable conditional field for the dimension but i never could manage it.
So then i tried to have it in a calculated expression (i transferred the feal NAME in an expression and tried to work it in there) but never made it too.
Any ideas?
Second question, what if i want to add another criteria related to another coloumn for instance like i would like to isolate the rows with NAME that is NULL AND the row that has a price that is 0.
Thanks a lot
Hi,
If you want to filter by NULL values, you have to mark them from the script like:
LOAD If(IsNull(NAME), 'Unknown', NAME) as NAME
....
Regards,
David
use the following in your script
NullAsValue NAME;
Set NullValue = '-'
THIS WAY YOU CAN SELECT THE NULL VALUES ON YOUR CHARTS OR LIST BOX