Filter Tmap null

[RVeitch_84]

I would like to filter out all output rows based on one row value if = null,

So in this example if, row4.re_id2 = null, I would not like to pass any of the other rows to the output.

Let me know if you have any other questions.

Thanks

[Anonymous · Accepted solution]

Hello,

In the tMap, you can click the filter button and write a filter expression to filter the output data.

Here is a KB article about: https://community.talend.com/s/article/tMap-expression-syntax-TCiHW

Let us know if it is what you are looking for.

Best regards

Sabrina

[gjeremy1617088143]

hi,So you have just to write row4.re_id2 == null in the output expression filter of the tmap output.

then only rows with re_id2 with null value will go to the output.

You can select the response of @xdshi as best answer she set you on the right path.

Send me Love and Kudos

[RVeitch_84]

Thanks for the quick reply

But I want the exact opopsite , if row4.re_id2 == null, then don't pass anything into the output for that row and all others?

So I also tried what I thought made sense which was the following and that did work.

row4.re_id2 != null

[Anonymous]

Hello,

You are on the right way. Nice work!

Best regards

Sabrina