Create if, then, else statements

Sv3n-Sk4
Level 3
Create if, then, else statements

Hello everyone,


Sorry to bother you but I am looking everywhere and can't find the Create if, then, else statements.

I would like to create a formule with the help of the creator that we can see here but I am not able to find where to get it.

Create if, then, else statements โ€” Dataiku DSS 11.0 documentation

 

Thanks a lot for the help.

0 Kudos
5 Replies
JordanB
Dataiker

Hi @Sv3n-Sk4,

Processors can be found in Prepare recipes. In a prepare recipe, select "+add a new step" and search for the processor (as shown below). Please let us know if you have any questions.

Screen Shot 2022-10-18 at 1.43.47 PM.png

Thanks!

Jordan

Sv3n-Sk4
Level 3
Author

Hey @JordanB ,

Thanks a lot for you quick answer!

I was looking where I should but unfortunately it seems my version (from where I work) hasn't got this processor....

Thanks anyway ๐Ÿ™‚

0 Kudos
JordanB
Dataiker

@Sv3n-Sk4 

No problem! And, so you're aware, this processor was released in DSS version 11.

Best,
Jordan

0 Kudos
Sv3n-Sk4
Level 3
Author

That's where the problem was.

I just learned we only still are at the 9.0 version.

I will try to find a way to create my if else statement!

Thanks a lot!

0 Kudos
JordanB
Dataiker

Hi @Sv3n-Sk4,

You can create an if/else statement with a formula processor in a prepare recipe. The statement could go something like this:

if(customer_id == col1, col2, col3) which resolves to if condition (customer_id) equals col1 then execute col2, else execute col3

Please let me know if you have any questions.

Thanks!
Jordan

0 Kudos