Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter row not equals to ""

Hi,

 

I had this issue. I want to filter all the rows where a specific column (last_appl_cryptogram) is "" or null. I am trying to using tFilter row with the following condition: 

 

 

out_microchip.last_appl_cryptogram != null || ! (out_microchip.last_appl_cryptogram.equals(""))

 

Am I missing something? Maybe I am not using tFilterRow in a proper way.

0683p000009M1hG.png0683p000009M1tu.png0683p000009M1lr.png

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

No I can't. Anyway, I solved now: it was because of the trim condition.


@uganesh wrote:
why donot you use tmap expression filter instead of tfilterrow?

you could add your condition there.

let me know if that works

 

View solution in original post

2 Replies
akumar2301
Specialist II
Specialist II

why donot you use tmap expression filter instead of tfilterrow?

you could add your condition there.

let me know if that works
Anonymous
Not applicable
Author

No I can't. Anyway, I solved now: it was because of the trim condition.


@uganesh wrote:
why donot you use tmap expression filter instead of tfilterrow?

you could add your condition there.

let me know if that works