topic Re: [resolved] tMap filter expression syntax doesn't seem to work as advertised in Talend Studio

[resolved] tMap filter expression syntax doesn't seem to work as advertised

Anonymous — Wed, 22 Mar 2017 00:26:53 GMT

According to everything I've read (Help, examples etc), the below syntax for an output filter in tMap should work:

But it doesn't seem to, at least for me. In fact, if I change the condition to != then all rows with Security_Category=="OS" are routed to this output.

However, this syntax works perfectly:

which is fine, I can now get it working properly. But does anyone know why the first version doesn't work? Am I doing something wrong, or is there some configuration I can look a that will give me some clues?

Thanks.

(talend version:
)

Re: [resolved] tMap filter expression syntax doesn't seem to work as advertised

Anonymous — Wed, 22 Mar 2017 00:40:37 GMT

...neither does the "click and paste your screenshot", it would seem. Oh well.

Not working filter syntax is
row1.Security_category=="OS"

Working syntax is
"OS".equalsIgnoreCase(row1.Security_category)

Version of Open Studio is 6.3.1

ta.

Re: [resolved] tMap filter expression syntax doesn't seem to work as advertised

Anonymous — Wed, 22 Mar 2017 01:36:09 GMT

This is a Java thing and is about equality. Basically when you use == you are checking to see if the objects are the same. Do they share the same memory? A real life example would be of two identical cars. They may look exactly same, may cost the same, may have the internal components, but they are not the same car. Car1==Car2 is False. But if you use the equals() method (or a variant of that) you are checking to see whether the contents of the object are the same. Or, using the car example, whether the cars are the same make, model and colour. Whether they "look" the same.
This is explained better in the link below....
http://www.programmerinterview.com/index.php/java-questions/java-whats-the-difference-between-equals-and/

Re: [resolved] tMap filter expression syntax doesn't seem to work as advertised

Anonymous — Wed, 22 Mar 2017 04:52:53 GMT

Thanks, that explains it for me.