Getting Boolean instead of integer in tmap, help needed

[SV1605718563]

Hello Team,

Just downloaded Talend Big data community version into my laptop and trying to do even and odd number printing to tlogrow.

1. added trowgenerator to the job
2. added tmap
3. added tlogrow-one for odd-one for even....later I would like to make it as one tlogrow.

The job is as below

In trowgenerator, created a column sq_id as integer with function numeric.sequence

in tmap, I am trying to use the mod function to get divisable as 1 or 0 to identify it as even or odd....the image is as below

I am getting error saying , type mismatch, cannot convert from boolean to integer

can someone help me here how to handle this?

Thanks

SV

[Anonymous]

Hi

Can you paste the expression in the post?

Regards

Shong

[Prakhar1 · Accepted solution]

You are writing expression in the value field of tMap.

Mathematical.MOD() == 1 will return true or false which is a Boolean value and you are trying to assign it on seq_id which is a integer.

You have to write this MOD() function in the filter condition on tMap on the top of output. 

[SV1605718563]

Hi @Shicong Hong​ ...I am able to fix this by assign the expression to a variable and it worked.

here is the expression: row1.sq_id%2==0?row1.sq_id+"-even":row1.sq_id+"-odd" ....thanks for your help.

[SV1605718563]

HI @prakhar dubey​ ....I will try your way also....I am able to fix this by assign the expression to a variable and it worked. here is the expression: row1.sq_id%2==0?row1.sq_id+"-even":row1.sq_id+"-odd" ....thanks for your help.

[SV1605718563]

This incident is closed...thanks to all