topic Re: Null Handling - String replacement in Tmap in Talend Studio

Null Handling - String replacement in Tmap

Anonymous — Fri, 20 Dec 2019 21:21:30 GMT

Hello,

I've searched the community and I thought the correct syntax for null string replacement is as such:

row2.Reason_Code == null ? "NA" : row2.Reason_Code

However, TMAP is giving me a String to Boolean Type Mismatch for some reason. What would be causing this?

Re: Null Handling - String replacement in Tmap

Raghuram_Puram — Sat, 21 Dec 2019 14:24:10 GMT

Check the datatype or Reason_Code in source and target schemas, there might have been a mismatch.
If datatype of Reason_Code is boolean and you're trying to assign a String value "NA" to it, error is thrown.

row2.Reason_Code == null ? true/false : row2.Reason_Code

Re: Null Handling - String replacement in Tmap

Jaggu1992 — Mon, 23 Dec 2019 11:04:15 GMT

Hi Raghuram,

Place that function in tmap in filter condition in Target. Then you wont get datatype mismatch error. And if you keep that functuntion in Expression Editor in tmap you will get datatype mismatch error.

Thanks,

Jagan.