topic Re: oracle decode in tmap expression builder in Talend Studio

oracle decode in tmap expression builder

Anonymous — Tue, 25 Sep 2018 13:47:30 GMT

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 — Tue, 25 Sep 2018 14:10:16 GMT

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

Anonymous — Tue, 25 Sep 2018 15:02:10 GMT

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

fdenis — Tue, 25 Sep 2018 15:05:42 GMT

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

fdenis — Tue, 25 Sep 2018 15:07:29 GMT

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

is that better?

fdenis — Tue, 25 Sep 2018 15:09:11 GMT

this translator is **bleep**.

Anonymous — Tue, 25 Sep 2018 15:18:08 GMT

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 — Tue, 25 Sep 2018 15:34:13 GMT

(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 — Tue, 25 Sep 2018 15:46:15 GMT

thx really appreciate it now works

fdenis — Tue, 25 Sep 2018 16:01:48 GMT

usually you tag as solve the solution not your post.