Search code examples
talend

How to ignore row which contain null in specific column in talend?

My talend job process is:

  • Read excel file
  • Insert Row in Table.

But I want to ignore row which contain NULL for specific column. Is there any way to ignore row which contain NULL for specific column?

Solution

  • You can use a filter in a tMap to filter out null columns :

    tFileInputExcel -- tMap -- tDB..

    in the tMap output filter, you can use the expression : 

    row.Column != null

    For the sake of completion, as mentioned by alex, you can also check for empty string: 

    row.Column != null && !row.Column.trim().isEmpty()

    I've added a trim, in case the string contains only whitespaces.