topic Oracle Decode Function. in Talend Studio

Oracle Decode Function.

ptremblay — Sat, 16 Nov 2024 14:20:55 GMT

Bonjour,
I'm new to TOS.
How can I achieve the equivalent of Oracle's Decode Function within tMap? What is the best way to achieve this in TOS?
Thanks.
PM

Re: Oracle Decode Function.

Anonymous — Thu, 05 Jun 2008 04:14:24 GMT

Hello

How can I achieve the equivalent of Oracle's Decode Function within tMap? What is the best way to achieve this in TOS?

Type in the code below in expression filed of tMap for example)

row1.supplier_id==1?value1:(row1.supplier_id==2?value2:value3)

Best regards

shong

Re: Oracle Decode Function.

Anonymous — Thu, 05 Jun 2008 08:09:40 GMT

Or in Perl:

$row1 == 1
    ? 'value1'
    : $row1 == 2
        ? 'value2'
        : 'other'

Re: Oracle Decode Function.

Anonymous — Tue, 08 Apr 2014 14:06:49 GMT

How can I used following condition in TOS
IIF(upper(STANDING_TAX)= 'GOOD' AND upper(STANDING_RA) = 'GOOD' AND upper(STANDING_OTHER) = 'GOOD' ,'1','2')
I have output field GOODSTD, but I want to check with 3 fields which are shown in above condition.

Re: Oracle Decode Function.

Anonymous — Tue, 08 Apr 2014 15:58:44 GMT

Hi rahul.nawale
If I understand you correctly, the original expression indicates the result will be "1" if all of the three conditions match, otherwise, it is "2", right?
Shong

Re: Oracle Decode Function.

Anonymous — Tue, 08 Apr 2014 16:22:19 GMT

yes shong. You are right.

Re: Oracle Decode Function.

willm1 — Tue, 08 Apr 2014 16:29:50 GMT

Hi... If you're doing this in tMap which accepts only ternary operators, it'd be:
STANDING_TAX.toUpperCase().equals("GOOD") && STANDING_RA.toUpperCase().equals("GOOD") && STANDING_OTHER.toUpperCase().equals("GOOD") ? "1" : "2"
If in tJava that accepts regular if-then-else, it'd be:

String STANDING_TAX = "";
String STANDING_RA = "";
String STANDING_OTHER = "";
String Output = "";
if (
STANDING_TAX.toUpperCase().equals("GOOD") && STANDING_RA.toUpperCase().equals("GOOD") &&
STANDING_OTHER.toUpperCase().equals("GOOD")
)
{
Output = "1";
}
else
{
Output = "2";
};
System.out.println("Output is... " + Output);

Re: Oracle Decode Function.

Anonymous — Tue, 08 Apr 2014 16:38:05 GMT

Thanks willm, its working.

Re: Oracle Decode Function.

willm1 — Tue, 08 Apr 2014 16:49:12 GMT

Glad to hear...