Null values removal from columns

[mani1304]

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.

[Anonymous]

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 🙂

[mani1304]

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 ?

[Anonymous]

Hi mani,

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

Thanks ,
Prabuj

[Anonymous]

@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 🙂