topic Null handling in multiple columns in Talend Studio

Null handling in multiple columns

Karthik_Kommarraju — Sat, 16 Nov 2024 00:35:10 GMT

Hello,

My requirement is check null in multiple columns, if null found in any column then mention the reason in error column. Do I need to write java code for that, or I can do it in tmap itself?

Kindly suggest.

For example 1:

Source:

ID Name Address City

1 Century abc

***********************************

Output:

ID Name Address City Error

1 Century abc City is null;

For example 2:

Source:

ID Name Address City

1 Century

***********************************

Output:

ID Name Address City Error

1 Century Address is null; City is null

Re: Null handling in multiple columns

billimmer — Wed, 17 Feb 2021 16:42:52 GMT

you can do this in tmap. For example:

row1.City==null ? "City is null" : row1.City

Re: Null handling in multiple columns

prg — Wed, 17 Feb 2021 16:53:14 GMT

Hello @Karthik Kommarraju,

Yes, this can be achieved using tMap.

You can check the source column if it is null and then print using expression builder in tmap.

row1.city==null ? "city is null" : row1.city

Please check the screenshots.

Let us know if it helps and then mark your case as solved (Kudos also accepted).

Regards,

Vaishnavi

Re: Null handling in multiple columns

Karthik_Kommarraju — Wed, 17 Feb 2021 17:24:36 GMT

But I also want if Address and City is null. then I want to have 'Address is null; City is null' in Error field

Re: Null handling in multiple columns

Karthik_Kommarraju — Wed, 17 Feb 2021 17:25:21 GMT

Thanks Vaishnavi. But I also want if Address and City is null. then I want to have 'Address is null; City is null' in Error field. Please check example 2.

Re: Null handling in multiple columns

prg — Wed, 17 Feb 2021 17:54:22 GMT

Hello @Karthik Kommarraju ,

You can create an expression using a ternary operator according to your requirement;

For example;

(row1.city==null && row1.address==null) ? "City and address is null"

: row1.city==null ? "City is null"

: row1.address==null ? "Adddress is null"

: "No Error"

Please note this is the sample expression. You can build your expression as per your needs.

Thanks!!

Re: Null handling in multiple columns

Karthik_Kommarraju — Wed, 17 Feb 2021 19:47:14 GMT

This may work. Thanks.