New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Visual recipe. formula

Solved!
Tong
Level 3
Visual recipe. formula

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
0 Kudos
1 Solution
TheophileT
Dataiker
Dataiker

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

View solution in original post

2 Replies
TheophileT
Dataiker
Dataiker

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

View solution in original post

Tong
Level 3
Author

@TheophileT That works!

0 Kudos
A banner prompting to get Dataiku DSS