topic Re: Filter on empty field in tmap in Talend Studio

Filter on empty field in tmap

INESBK — Tue, 30 May 2017 11:43:26 GMT

Hello,

I have a .dbf file that contains an empty line (the fields are empty) I would like to filter this line. I used the filter expressions but it dosen't work.

Also i tried with isEmpty() ----

!row1.DATE_NDX.isEmpty() && !row1.TIME_H.isEmpty() && !row1.TIME_M.isEmpty()

But the same problem.

Although I have already checked the box "ignore null as the source data" before tmap

Thank you in advance.

Re: Filter on empty field in tmap

TRF — Tue, 30 May 2017 20:54:05 GMT

Did you try this:
row1.DATE_NDX != null &&
!row1.DATE_NDX.equals("") &&
row1.TIME_H != null &&
!row1.TIME_H.equals("") &&
row1.TIME_M != null &&
!row1.TIME_M.equals("")

Else, get the source code line number from exception message, then go to code tab and check the operation which crash the job.

Re: Filter on empty field in tmap

INESBK — Wed, 31 May 2017 08:03:27 GMT

Thanks for your replay. Here is the expression wich resolved my problem

row1.DATE_NDX != null &&
!row1.DATE_NDX.equals("0") &&
row1.TIME_H != null &&
!row1.TIME_H.equals("0") &&
row1.TIME_M != null &&
!row1.TIME_M.equals("0")

Best regards.