topic handling null from source data in Talend Studio

handling null from source data

sushantk19 — Sat, 16 Nov 2024 01:26:10 GMT

My logic is based on 2 source fields. both are of INTdatatype.

i have the logic as (row1.registrationchannel==null && row1.is_from_app==null)?null:null.

With the above logic, it gives me NULL pointer exception as below if both the columns have NULL values.

Exception in component tMap_1 (job_DM_001_Customer)

java.lang.NullPointerException

Is it possible to handle this in ETL or tmap somehow?

Re: handling null from source data

vikramk — Fri, 18 Sep 2020 11:14:04 GMT

Could you check the false condition, you are trying to give null for both true and false condition also. which is not accepted

Re: handling null from source data

Anonymous — Mon, 21 Sep 2020 06:54:54 GMT

Hello,

Is your source field INT or integer data type?

Schemas allow you to specify if a column is nullable. This usually determines if it is an int or an Integer. You need to make it nullable.

Best regards

Sabrina

Re: handling null from source data

manodwhb — Tue, 22 Sep 2020 05:30:05 GMT

@Sushant Kapoor ,check the below screens should work.

Thanks,

Manohar

Re: handling null from source data

sushantk19 — Tue, 22 Sep 2020 09:43:43 GMT

what is difference between the 2? i have used:

(row1.registrationchannel==null && row1.is_from_app==null)?null:null.

Re: handling null from source data

sushantk19 — Tue, 22 Sep 2020 09:44:27 GMT

yes, both are INT fields. Target field is defined as Nullable only in Database.

Re: handling null from source data

sushantk19 — Tue, 22 Sep 2020 09:46:25 GMT

can you be more clear. how do i check for false condition? can you update my logic and show me?

Re: handling null from source data

manodwhb — Tue, 22 Sep 2020 09:59:12 GMT

@Sushant Kapoor .check the below links.

https://www.tutorialspoint.com/difference-between-an-integer-and-int-in-java#:~:text=A%20Java%20both%20int%20and,Integer%20is%20of%20class%20type.&text=A%20int%20is%20a%20data,type%20int%20into%20an%20object.

https://stackoverflow.com/questions/8660691/what-is-the-difference-between-integer-and-int-in-java

Thanks,

Manohar