topic Re: Filter Tmap null in Talend Studio

Filter Tmap null

RVeitch_84 — Fri, 15 Nov 2024 23:57:05 GMT

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 — Thu, 15 Jul 2021 06:20:58 GMT

Hello,

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

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

Best regards

Sabrina

gjeremy1617088143 — Thu, 15 Jul 2021 07:24:49 GMT

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 — Fri, 16 Jul 2021 15:19:07 GMT

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 — Mon, 19 Jul 2021 04:25:18 GMT

Hello,

You are on the right way. Nice work!

Best regards

Sabrina