Visual recipe. formula
Options
Tong
Registered Posts: 13 ✭✭✭✭
Hi, I have to colume of various values, like below. I want to set '0' to be 'ture' and all other values to be 'false'. How can I realize it via fomula function? thanks a lot!
| 1 |
| 1 |
| 1 |
| 3 |
| 3 |
| 1 |
| 1 |
| 2 |
| 0 |
| 3 |
| 2 |
| 1 |
Best Answer
-
Hi,
Assuming you had a typo in your question and that you want true/false, if you have a integer column `MyValue` you could use
MyValue == 0
You can find more information about what you can do with the formula here: https://doc.dataiku.com/dss/8.0/advanced/formula.html#boolean-values
Answers
-
@TheophileT
That works!