How to do IF-THEN-ELSE in Data Manager?

[fan_chiu]

Hi Experts,

How to do IF-THEN-ELSE in Data Manager?

I can only find isValid(), but it's different than the logic of if-then-else.

Best Regards,

Fan

[Former Member · Accepted solution]

Hi Fan,

You will specify an IF-THEN-ELSE clause in Data Manager by creating a "New Condition" and not from the "Expression Editor"

There you will have full flexibility to create conditional expressions:

You can even create complex conditions by combining multiple cases:

I hope you'll find it helpful.

Full documentation can be found in the user's guide:

• Getting Started with Data Manipulation 3.0
• page 23: 3.2.2.11 Defining a Condition

Serge

[marc_daniau]

You can also use the if function in the formula editor ; an example of formula for a target variable Is_A_Churner:

if ( isNull(TERMINATION_DATE), "No", "Yes" )