topic Re: Null values removal from columns in Talend Studio

Null values removal from columns

mani1304 — Wed, 12 Jun 2019 14:56:28 GMT

Hi,
I have 2 columns in tmap output and it has null values, Is there any way, I can only take non-nullable values in those columns. I am using ! isNull etc but it is giving Boolean to string issue.
And if I can get the count of non null able fields for both the columns, if I use tfilter, it will filter on the basis of one column, but I want to filter both the columns from null values.

Re: Null values removal from columns

Anonymous — Wed, 12 Jun 2019 15:51:24 GMT

Hi,

Could you please try below method in your tMap output filter expression?

!Relational.ISNULL(row1.col1) && !Relational.ISNULL(row1.col2)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Null values removal from columns

mani1304 — Thu, 13 Jun 2019 03:20:26 GMT

Both are separate columns and I want to take only non nullable fields on to
them, I used this and this was also giving me error.
Requirement is like, we have a input_field 1 and input_field 2, and both
fields have nullable records after deriving from variables , now in
output_field1 and output_field2 should have only non nullable records. Not to apply in common out expression, I think it would be in expression filter in column side, how to do this there ?

Re: Null values removal from columns

Anonymous — Thu, 13 Jun 2019 05:21:55 GMT

Hi mani,

Could you share us the screenshot for better understanding ? And what's your source and target data types ?

Thanks ,
Prabuj

Re: Null values removal from columns

Anonymous — Thu, 13 Jun 2019 13:52:54 GMT

@mani1304

Could you please share the source and target systems where you are planning to store data? Also please share the job flow so that we will get more idea about your objective.

In between, could you please advise why the above method to filter out the data from tMap is not suitable for your use case?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂