Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
Hello,
You are on the right way. Nice work!
Best regards
Sabrina