Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

TFilterRow -String Emply check

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.

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi,

 

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

0683p000009M6IT.png

 

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 🙂

Anonymous
Not applicable
Author

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

Regards
Shong