topic TFilterRow -String Emply check in Talend Studio

TFilterRow -String Emply check

Anonymous — Sat, 16 Nov 2024 05:19:20 GMT

Hello,

I have Talend job that read csv file and insert only rows that colonn 'Field1' (string) is null.

I used TFilterRow and this condition:

input_row.NumEngagement.equals("")

but all rows was inserted in Salesforce.

Can someone help me.

Re: TFilterRow -String Emply check

Anonymous — Thu, 11 Jul 2019 03:21:46 GMT

Hi,

Its better to hanle through tMap using !Relational.ISNULL() function. Please refer the below sscreenshot for sample.

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: TFilterRow -String Emply check

Anonymous — Thu, 11 Jul 2019 03:23:35 GMT

Hi
To check if the value is null, use this expression in the advanced model field:
input_row.NumEngagement==null

Regards
Shong