topic Division in a tMap in Talend Studio

Division in a tMap

Anonymous — Sat, 16 Nov 2024 12:30:43 GMT

what's the problem, exactly?

Re: Division in a tMap

Anonymous — Wed, 14 Dec 2011 04:50:23 GMT

Hi
Don't use the 'Test' button, open the code tab to see whether there are compilation error in the generated code. If you want to see the execution result, link a tLogRow after tMap and execute the job.
Best regards
Shong

Re: Division in a tMap

Anonymous — Wed, 14 Dec 2011 05:22:13 GMT

thanks!
As you suggested, I have added tLogRow to the job design.
But, Why this error occured? Please assist me.
Exception in component tMap_1
java.lang.NullPointerException
at tbmd_spot_ord.tbmd_bydd_bnd_prc_valu_0_1.TBMD_BYDD_BND_PRC_VALU.tFileInputPositional_1Process(TBMD_BYDD_BND_PRC_VALU.java:2551)
at tbmd_spot_ord.tbmd_bydd_bnd_prc_valu_0_1.TBMD_BYDD_BND_PRC_VALU.tOracleConnection_1Process(TBMD_BYDD_BND_PRC_VALU.java:456)
at tbmd_spot_ord.tbmd_bydd_bnd_prc_valu_0_1.TBMD_BYDD_BND_PRC_VALU.runJobInTOS(TBMD_BYDD_BND_PRC_VALU.java:3628)
at tbmd_spot_ord.tbmd_bydd_bnd_prc_valu_0_1.TBMD_BYDD_BND_PRC_VALU.main(TBMD_BYDD_BND_PRC_VALU.java:3492)

Re: Division in a tMap

Anonymous — Wed, 14 Dec 2011 07:28:15 GMT

idb008,
This means one of the input columns has a NULL value where it shouldn't. I'm guessing it's column8 but i don't know since I don't know your job.
When the columns needs to do some kind of calculation and it contains a null value u will get errors.
If the problem is your column 8, replace your calculation by the following:
row1.NewColumn8 == null ? 0 : ( row1.NewColumn8 / 100 )
This should resolve your error.
Regards

Re: Division in a tMap

Anonymous — Thu, 15 Dec 2011 00:45:54 GMT

Thanks mpa. It worked!