Oracle Decode Function.

[ptremblay]

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

[Anonymous]

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

[Anonymous]

Or in Perl:

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

yes shong. You are right.

[willm1]

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);

[Anonymous]

Thanks willm, its working.

[willm1]

Glad to hear...