Talend community forum / [resolved] Expression in tMap

Piero001 · 2012-05-30 10:26:20

Tags: [difference, expression, float, java, sql, tmap]

Hello there,

i need help with tMap expression. Actually i don't know anything of Java and SQL Language. Therfore Talend is a very helpful tool for me. But for my current task I need to know how to give some simple expressions into tMap.

As you can see in the screenshoot, I have two "column1" and "column2". All columns are in float. I want the difference between the two values in the "D" column.

I tried the following expression in a test tMap:

Code:

row1.column1 - row1.column2

But it just gives me a nullPointerException...

Can someone help me?

Regards,

Piero

Uploaded Images

pedro · 2012-05-30 10:29:12

Hi

Try this expression.
(row1.column1==null?0:row1.column1) - (row1.column2==null?0:row1.column2)

Regards,
Pedro

Piero001 · 2012-05-30 10:42:59

thank you Pedro, this is working fine!

Regards,

Piero

Piero001 · 2012-05-31 15:20:22

Can you give me the same code for the Typ BigDecimal?

Piero001 · 2012-06-01 10:48:20

the code does not work with big decimal
Can you help me pls?

Regards,

Piero

pedro · 2012-06-01 11:00:59

Hi

Try this expression.

Code:

(row1.newColumn==null?BigDecimal.valueOf(0):row1.newColumn).subtract((row1.newColumn1==null?BigDecimal.valueOf(0):row1.newColumn1))

Regards,
Pedro

Piero001 · 2012-06-01 11:31:15

thank you so much!

regards,

Piero

Announcement

Unanswered posts

#1 2012-05-30 10:26:20

[resolved] Expression in tMap

Code:

#2 2012-05-30 10:29:12

Re: [resolved] Expression in tMap

#3 2012-05-30 10:42:59

Re: [resolved] Expression in tMap

#4 2012-05-31 15:20:22

Re: [resolved] Expression in tMap

#5 2012-06-01 10:48:20

Re: [resolved] Expression in tMap

#6 2012-06-01 11:00:59

Re: [resolved] Expression in tMap

Code:

#7 2012-06-01 11:31:15

Re: [resolved] Expression in tMap

Board footer