topic Re: tMap Expression Builder - IF-ELSE statements in Talend Studio

tMap Expression Builder - IF-ELSE statements

Anonymous — Sat, 16 Nov 2024 13:19:49 GMT

Hi folks,
Just wondering if it is possible to create if-else statements in the tMap expression builder. If you could give some examples it would be much appreciated.
Thank you in advance!

Re: tMap Expression Builder - IF-ELSE statements

alevy — Fri, 30 Jul 2010 01:42:45 GMT

Certainly is. Use standard Java syntax: <boolean test condition>?<then expression>:else expression. For example:

row1.myKey.equals("FirstValue")?1:0

Re: tMap Expression Builder - IF-ELSE statements

_AnonymousUser — Mon, 22 Oct 2012 09:35:52 GMT

Thanks. I was also looking for this and it worked fine. Is there a reference for all these syntax. I dont find it in the user guide or reference guide. I am not a java developer and would like to learn these just for the purpose of using talend effectively.

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Mon, 22 Oct 2012 10:47:04 GMT

Thanks. I was also looking for this and it worked fine. Is there a reference for all these syntax. I dont find it in the user guide or reference guide. I am not a java developer and would like to learn these just for the purpose of using talend effectively.

Unfortunately, there is no a document for these syntax, but you can always learn these knowledge and experience from Talend forum.

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Wed, 06 Feb 2013 18:09:54 GMT

Hi everyone,
How about this expression at tMap? Could you please help me on the Java syntax?
Example expression at output ColumnC,
if row1.Year_ID < 2009
2000+row2.ColumnA
else
2008+row2.ColumnA
For '+', it's concatenating the value rather than actual add operation.
Your help is very much appreciated!

Re: tMap Expression Builder - IF-ELSE statements

alevy — Wed, 06 Feb 2013 22:04:58 GMT

Presuming that Year_ID and ColumnA are integers, then just:
row1.Year_ID < 2009 ? 2000+row2.ColumnA : 2008+row2.ColumnA

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Thu, 07 Feb 2013 01:36:17 GMT

What if..
Year_ID is int
ColumnA is double
output ColumnC is double
row1.Year_ID < 2009 ? 2000+(Integer.parseInt(row2.ColumnA)) : Integer.parseInt(2008+row2.ColumnA)
I tried but it returns error.
Please help me, thanks!

Re: tMap Expression Builder - IF-ELSE statements

alevy — Thu, 07 Feb 2013 02:05:12 GMT

What's the error?!

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Thu, 07 Feb 2013 02:56:18 GMT

Hi Alevy,
Sorry, looks like I didn't think hard. tConvertType simply solved my problem.
But I have another problem, what if I have 3 conditions?
Is my design correct?
row1.Year_ID < 2009 ? 2000+row2.F0015 : row1.Year_ID = 2009 ? 2008+row2.F0015 : 2012+row2.F0015

Thanks 😃

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Fri, 16 Sep 2016 15:18:59 GMT

hello
can anyone please tell me how to divide a data but not all of them
for example i've the row 'type' witch content so many informations , i want just the 'type' == "stock" i want to have them like they are but when 'type' != "stock" i want to divide all the datas /7
so Stock is for the weekends and the others are for the days
thanks

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Tue, 07 Aug 2018 13:30:17 GMT

hello

i want to do this condition with tmap

Répéter VU_ALIM_TABLEAU_INTEGRATION.DATE + 1 Jusqu’à Date d’expédition - 1

@alevy wrote:
Certainly is. Use standard Java syntax: <boolean test condition>?<then expression>:else expression. For example:
row1.myKey.equals("FirstValue")?1:0

please can anyone help me please and thanks

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Tue, 04 Sep 2018 06:26:25 GMT

Hello folks,

How to use this if-else statement in Talend Expression Builder. Please help me on this

Trim(( IF IsNotNull((ffr_dcconso_ref_initial.TITLE)) THEN (ffr_dcconso_ref_initial.TITLE) ELSE (""))) <> ""

then

Trim(( IF IsNotNull((ffr_dcconso_ref_initial.TITLE)) THEN (ffr_dcconso_ref_initial.TITLE) ELSE (""))) = "1"

then "MR"

else

else ""

--FLAG

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Wed, 12 Sep 2018 10:27:31 GMT

Hello,

You can use ternary if-else operator in tMap expression.

Condition?value if true: value if false

Best regards

Sabrina

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Thu, 04 Oct 2018 04:47:19 GMT

how can i get if condition,

if source = 'actif' then '1'

else if '0'

Re: tMap Expression Builder - IF-ELSE statements

Anonymous — Thu, 04 Oct 2018 19:42:14 GMT

(source == actif)?1:0