topic Re: Expression Builder statcatcher in Talend Studio

Expression Builder statcatcher

Anonymous — Wed, 19 Sep 2018 00:34:30 GMT

Hi,

I am trying to build an expression for our Meta data table using the tStatCatcher.

I would like to populate a field with the Moment (Timestamp), only if the Message (String) = "failure"

My current expression is: "failure".equals(row5.message)?Null:row5.moment

Getting an error. "Null cannot be resolved to a variable."

However the component is failing, is anyone able to provide some assistance with the logic?

Thank you.

fdenis — Wed, 19 Sep 2018 08:32:14 GMT

try it
(Date)("failure".equals(row5.message)?Null:row5.moment)
or
"failure".equals(row5.message)?(Date)Null:row5.moment
to force Null to be a Date

Anonymous — Thu, 20 Sep 2018 08:41:41 GMT

Hi Francois,

With (Date)("failure".equals(row5.message)?Null:row5.moment) i am receiving the attached error.

"Null Cannot be resolved to a variable".

fdenis — Thu, 20 Sep 2018 08:48:34 GMT

click on code tab
go to the first error (underlined in red / reg point on the right bar)
can you show me this code part?

Anonymous — Thu, 20 Sep 2018 08:53:34 GMT

fdenis — Thu, 20 Sep 2018 08:57:44 GMT

in designer tab replace Null by null