Checking for Null and Blank space

Six Stars

Checking for Null and Blank space

Team, I have the below scenario, I have 3 columns from source for which I need to do null & blank space check, if its satisfied I need to reject those records. I’m doing the same in tmap component by using the option “Capture Output Rejects” Column 1 : EMP_ID, interger Column 2 : JOIN_DATE, Date(dd-MMM-yy) Column 3 : EMP_NAME, string Can you please let me know the condition to put in the expression filter. Because checking for null & blank space differs between datatypes string, integer and date.
Ten Stars

Re: Checking for Null and Blank space

Checking for null is the same operation across all non-primitive data types: rowX.colX == null. If the integer column in your schema has Nullable checked, it will be of type Integer and can be null checked. If nullable is not checked, any null values from the input will be zero.

A blank space check would only apply to a string. You can check this with rowX.colX.isEmpty()
Six Stars

Re: Checking for Null and Blank space

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch