topic Re: increment a Big Dec context variable in tMap in Talend Studio

increment a Big Dec context variable in tMap

Anonymous — Tue, 10 Oct 2017 19:41:09 GMT

I am trying to conditionally increment a Big Dec context variable based on certain field values

currently I can do this via tJavaRow component, but want to bring this into a tMap - so the logic is centralized

this code currently works in tJavaRow

but when I try to code something similar in the Var Expression builder, I receive "Type mismatch: cannot convert from Number&Comparable<?> to BigDecimal"

I have tried to search online in several places to address this issue but have had zero luck

do you have any advice

thank you in advance

Re: increment a Big Dec context variable in tMap

Anonymous — Thu, 02 Nov 2017 06:09:53 GMT

In your expression remove "context.LastName_NullCount ="
In line 3 as shown in picture

Re: increment a Big Dec context variable in tMap

TRF — Thu, 02 Nov 2017 09:58:03 GMT

Hi,

Not very clean in my opinion, but if I understand your request you should try this.

Create a BigDecimal variable in the tMap, enter the expression builder and type the code:

null; // This is here because you need to affect a value to the variable
if(!"A".equals("B")) // Replace this with your condition
	context.test = context.test.add(new BigDecimal(1)); // Replace with your context variable

As you can see, the expression builder can be used to enter a piece of Java code which is not used for the variable assignment.

The only rule is that the 1st line must reprsent the right part of the variable assignment, but of course, you are not forced to use this variable anywhere.

So, this is what you expect: the context variable is incremented by 1 for each input row under condition.

Hope this helps.

Re: increment a Big Dec context variable in tMap

TRF — Fri, 03 Nov 2017 10:35:55 GMT

Does this help?
If so, please mark the case as solved.
Kudos also accepted.

Re: increment a Big Dec context variable in tMap

Anonymous — Fri, 03 Nov 2017 13:51:33 GMT

TRF

thank you

this works - sorry for not responding to you sooner

your efforts are much appreciated