topic Re: expression builder if, else in Talend Studio

expression builder if, else

_AnonymousUser — Sat, 16 Nov 2024 13:21:03 GMT

Hello,
I've got aquestion: Could I use in expression builder in tMap string value? If i write this (and I had verified that the row1.MessageName is really value ServiceModified), output from tMap is nothing..
row1.MessageName == "ServiceModified" ? row1.message : "nothing"
thanks for your answer
Karl

Re: expression builder if, else

Anonymous — Thu, 15 Jul 2010 17:03:11 GMT

Hello,
In java the correct expression is :

"ServiceModified".equals(row1.MessageName)? row1.message : "nothing"

Re: expression builder if, else

_AnonymousUser — Thu, 15 Jul 2010 18:15:30 GMT

Thank you very much. One more question please - if i want to do nothing in place of send to output string "nothing", could you give me advice once more please?
Karl

Re: expression builder if, else

Anonymous — Thu, 15 Jul 2010 20:30:06 GMT

What do you mean by nothing ? You can send back an empty string by writing "" in place of nothing or null by typing null

Re: expression builder if, else

_AnonymousUser — Thu, 15 Jul 2010 22:32:31 GMT

I don't want send anything except the case "ServiceModified".equals(row1.MessageName). I know if i place "" i send empty string (in my case to ibm mq). I want send a string only when the case is exactly matching my filter..

Re: expression builder if, else

Anonymous — Thu, 15 Jul 2010 22:46:17 GMT

So return null.
"ServiceModified".equals(row1.MessageName)? row1.message : null

Re: expression builder if, else

_AnonymousUser — Thu, 15 Jul 2010 23:14:06 GMT

if i write "ServiceModified".equals(row1.MessageName)? row1.message : null in case that doesn't match my filter i have got in ibm mq queue message with data null. I don't want send no message in this case...maybe its problem with my english

Re: expression builder if, else

Anonymous — Fri, 16 Jul 2010 04:40:23 GMT

Hi Karl32,
I already experienced that kind of logic and it made me cry what I did is, I didn't put my condition in tMap expression builder, i used the tFilterRow(I filter out first those data that satisfy my condition) then connect to tMap. Because I think, only one line "If" statement can be done in tMap expression builder. I hope you got my point.
Regards,

Re: expression builder if, else

Anonymous — Fri, 16 Jul 2010 08:27:53 GMT

So, in tMap I can't filter by conditions and decided if message was sent or not? in attachment you can see my case. mominput (xmlmessage) - some balast - parsing xml - filtering by parsed conditions - sending messages by sorted conditions (if condition1 = 1 send to queue1, if condition1 = 2 send to queue2 etc). In this case ("condition".equals(row1.MessageName)? row1.message : null) is happening that the message was send to all queues. My goal is to send only to one queue that meet my conditions.

Re: expression builder if, else

Anonymous — Fri, 16 Jul 2010 08:34:32 GMT

hi,
why don't use the filter integrated in tMap?
only row1.value .equals(context.MessageName) will be "propagated".
result :

Démarrage du job filterMap a 09:29 16/07/2010.
connecting to socket on port 3537
connected
1|100
disconnected
Job filterMap terminé à 09:29 16/07/2010.

regards
laurent

Re: expression builder if, else

Anonymous — Fri, 16 Jul 2010 09:32:47 GMT

I'm sorry, but i think I'm little blocked. I want to send field "message" by filtering field "MessageName" to various queues as you can see in my case. I want to use filter in tMap, I had defined variables, but I can't get your point

Re: expression builder if, else

Anonymous — Fri, 16 Jul 2010 12:32:23 GMT

currently i do it with tFilterRow. I cannot find a way to do this with condition in expression builder in tMap. Thanks all.

Re: expression builder if, else

Anonymous — Fri, 16 Jul 2010 13:30:57 GMT

ok,
do it step by step
first we got some different value "in" and compare with context.messageName.
In the output flow , first we catch the flow where equals context.messageName. (tlogrow 1)
second we reject those who don't match ... (reject context message)
But we also can add another filter to those output flow (tlogrow 2 3)
and so on
Note difference between reject of input flow and reject of the filters designed in the output schema.
hope it helps
regards
laurent

Re: expression builder if, else

Anonymous — Tue, 20 Jul 2010 10:06:39 GMT

Thanks a lot!!!!