Error while assign values to null in tmap

rp2018 — Mon, 25 Jun 2018 16:50:46 GMT

I'm creating 2 variables in tmap and need to assign value to a null.

Source:

Deleted column is boolean type

SVamount column is BigDecimal type

Vars are created using this:

row10.Deleted==null?1:row10.Deleted

row10.SVamount==null?new BigDecimal(0):row10.SVamount

When I take these two vars on the output filter, it errors out with.

Type mismatch: cannot convert from ObjectComparable<?>Serializable to boolean.

Re: Error while assign values to null in tmap

manodwhb — Tue, 26 Jun 2018 06:59:50 GMT

@rp2018,you need to use below way for vars.since 1 will not able to convert to Boolean.

Vars are created using this:

row10.Deleted==null?true:row10.Deleted

row10.SVamount==null?new BigDecimal(0):row10.SVamount