topic Re: Multiple If/case Statement in tMap Expression Builder in Talend Studio

Multiple If/case Statement in tMap Expression Builder

Radnip — Sat, 16 Nov 2024 13:18:34 GMT

I seem to be doing this all the time, whenever there is a simple IF I just put it in the Expression builder eg:
myValue == "test" ? "True" : "False"
Now if I want to have multiple if's in the expression builder I'm having to either create a separate method and call it from the expression builder or use a tJavaRow. Is there a way to do the following in the expression builder directly as it just seems overkill to go out to a separate method/tJavaRow:
if (myValue == "test"){
return "True";
}elseif(myValue == "something else"{
return "False";
}else{
return "True";
}

Re: Multiple If/case Statement in tMap Expression Builder

Anonymous — Thu, 19 Aug 2010 14:19:09 GMT

Hi,
the following expression should be equivalent to the IF statement you posted:

(myValue == "test") ? "True" :  (  ( myValue == "something else" ) ? "False" : "True" )

The complexer the if statement is, the harder this is to read / understand though 😞
Anyways, hope this helps!

Regards
Christian

Re: Multiple If/case Statement in tMap Expression Builder

Anonymous — Thu, 19 Aug 2010 14:21:10 GMT

Hello gabbs,
One thing you could do is : myValue == "test" ? "True" : (myValue == "something else")? "False" : "True" that would be a translation of your code above.
Hope it helps!

Re: Multiple If/case Statement in tMap Expression Builder

Anonymous — Thu, 19 Aug 2010 14:22:23 GMT

Aye someone was quicker

Re: Multiple If/case Statement in tMap Expression Builder

Anonymous — Thu, 19 Aug 2010 14:25:31 GMT

Aye someone was quicker

😉 only a few seconds ... but comforting, to see, that we are of the same oppinion!

Re: Multiple If/case Statement in tMap Expression Builder

Anonymous — Tue, 26 Apr 2016 14:59:21 GMT

IIF ( (ISNULL(LE_CD) AND (MD_SOURCE_SYSTEM_O='15' OR MD_SOURCE_SYSTEM_O ='16')), OPERATING_UNIT_ID,
IIF ( (ISNULL(LE_CD) AND (MD_SOURCE_SYSTEM_O = '25' OR MD_SOURCE_SYSTEM_O = '28' OR MD_SOURCE_SYSTEM_O = '27')),
IIF(INSTR(OPERATING_UNIT_NAME_INV_LINE,'-',1) > 0, SUBSTR(OPERATING_UNIT_NAME_INV_LINE,1,(INSTR(OPERATING_UNIT_NAME_INV_LINE,'-',1)- 1))),
LE_CD))..in talend

Re: Multiple If/case Statement in tMap Expression Builder

Radnip — Fri, 29 Jul 2022 14:03:52 GMT

LOL just searched for the same question... and look what just popped up... answers to the question I asked 12 years ago. But looks like I never said thanks... so a belated 12 year thanks to @Remi Masri @Christian Riedel 😁