Talend community forum / tMap Expression Builder - IF-ELSE statements

talend_newbie · 2010-07-29 19:09:06

Tags: [if stmts, java, PostgreSQL, tmap, tos3.0.0]

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!

alevy · 2010-07-30 02:42:45

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

Code:

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

kp.balaji123 · 2012-10-22 10:35:52

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.

shong · 2012-10-22 11:47:04

kp.balaji123 wrote:
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.

Rozie · 2013-02-06 19:09:54

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!

Last edited by Rozie (2013-02-06 19:11:37)

alevy · 2013-02-06 23:04:58

Presuming that Year_ID and ColumnA are integers, then just:

row1.Year_ID < 2009 ? 2000+row2.ColumnA : 2008+row2.ColumnA

Rozie · 2013-02-07 02:36:17

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!

alevy · 2013-02-07 03:05:12

What's the error?!

Rozie · 2013-02-07 03:56:18

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

Last edited by Rozie (2013-02-07 04:47:02)

Announcement

Unanswered posts

#1 2010-07-29 19:09:06

tMap Expression Builder - IF-ELSE statements

#2 2010-07-30 02:42:45

Re: tMap Expression Builder - IF-ELSE statements

Code:

#3 2012-10-22 10:35:52

Re: tMap Expression Builder - IF-ELSE statements

#4 2012-10-22 11:47:04

Re: tMap Expression Builder - IF-ELSE statements

kp.balaji123 wrote:

#5 2013-02-06 19:09:54

Re: tMap Expression Builder - IF-ELSE statements

#6 2013-02-06 23:04:58

Re: tMap Expression Builder - IF-ELSE statements

#7 2013-02-07 02:36:17

Re: tMap Expression Builder - IF-ELSE statements

#8 2013-02-07 03:05:12

Re: tMap Expression Builder - IF-ELSE statements

#9 2013-02-07 03:56:18

Re: tMap Expression Builder - IF-ELSE statements

Board footer