Six Stars

Filter on empty field in tmap

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.

vide.PNGCapture.PNG

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 

Capture.PNG

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Filter on empty field in tmap

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.

2 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Filter on empty field in tmap

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.

TRF
Six Stars

Re: Filter on empty field in tmap

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.