oracle decode in tmap expression builder

[Anonymous]

Hi I have a decode below but want to have more than one value. How do I separate the expression

row1.STATUS.equals("Active")?"1":row1.STATUS   row1.STATUS.equals("Inactive")?"0":row1.STATUS 

[fdenis]

(row1.STATUS.equals("Active"))?"1" row1.STATUS.equals("Inactive"))?"0":row1.STATUS

[Anonymous]

What does the happy face mean for a separator? It still doesn't work it only works if I use one value

[fdenis]

it's not an unhappy face it's : and (
it's the smily translator

[fdenis]

(row1.STATUS.equals("Active"))?"1"row1.STATUS.equals("Inactive"))?"0":row1.STATUS

is that better?

[fdenis]

this translator is **bleep**.

[Anonymous]

Sorry new to this but below is what I put in and get an error is the syntax correct

(row1.STATUS.equals("Active"))?"1":row1.STATUS.equals("Inactive"))?"0":row1.STATUS

[fdenis]

(row1.STATUS.equals("Active"))?"1": (row1.STATUS.equals("Inactive"))?"0":row1.STATUS

it's inline if:

(contition)?ifConditionIsTrue:else

so you can write :

(contition1)?ifCondition1isTruecontition2)?ifCondition2isTrue:else

[Anonymous · Accepted solution]

thx really appreciate it now works

[fdenis]

usually you tag as solve the solution not your post.