...
...
...
Available as of Datameer X v6.3
Syntax
CASE(<default value>; <any>; <case 1>; <return value 1>; <case 2>; <return value 2>; ...)
...
| Column1 | CASE returns |
|---|---|
| org | 1 |
| gov | 2 |
| mil | NULL |
| biz | 0 |
| com | 3 |
| net | 0 |
CASE("10 or under";GE(#Column1;11);"Over 10")
| Column1 | CASE returns |
|---|---|
| 2 | 10 or under |
| 4 | 10 or under |
| 6 | 10 or under |
| 8 | 10 or under |
| 10 | 10 or under |
| 12 | Over 10 |
| 14 | Over 10 |
| 16 | Over 10 |
| 18 | Over 10 |
| 20 | Over 10 |
...