topic Re: tMap conditional formula in Talend Studio

tMap conditional formula

Anonymous — Wed, 06 Mar 2019 14:01:03 GMT

I am trying to write a condition in my tMap translation. It is giving me an error when trying to run. Essentially, I have a required field I am trying to populate on the Output. From the input, I first want to check one of the columns for null. If it is null, I want to use a different column to populate output. Here is what I have written, not sure what I am missing:

row1.Field1 = null ? row1.Field2 : row1.Field1

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 14:15:08 GMT

Also, I have tried comparing using = and ==. Either way, I am getting an error when the first field is blank and it is not populating it the 2nd field.

Re: tMap conditional formula

akumar2301 — Wed, 06 Mar 2019 14:56:24 GMT

(row1.Field1 == null || row1.Field1.trim().length() == 0 )? row1.Field2 : row1.Field1

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 15:06:02 GMT

@steeld95 the one which @uganesh sent will work, even i used it before, specially when we have empties other then null it will be very helpful

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 15:07:11 GMT

Thank you @uganesh. It is now giving me a different error. It is saying:

Token<END-OF-STATEMENT> was not valid. Valid tokens: ? : <FLOAT> <BIGINT> <DECIMAL>

It is all string fields. The input fields are stings and the output field is a string.

I appreciate your help!

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 15:18:13 GMT

(row1.Field1 == null || StringHandling.LEN(row1.Field1)== 0 )? row1.Field2 : row1.Field1

Re: tMap conditional formula

akumar2301 — Wed, 06 Mar 2019 15:19:11 GMT

Error looks unrelated.Can you please verify and confirm that , this error comes only with above expression.

Are you using any database Query before. usually these errors are databse related.

can you please give your job screenshots.

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 15:21:45 GMT

@uganesh the above function i mentioned just now may work, let @steeld95 try it and let us know

Please dont forget to give kudos and accept solution if it worked @steeld95

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 15:21:54 GMT

Hi,

Seems you are trying to load the String value to a database like DB2 where the data is in different format.

Could you please share the screen shot of the job flow and the component where it is erroring out? There could be some data type mismatch but getting the full error and screen shot of the job only can help us to dig further.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tMap conditional formula

Anonymous — Wed, 06 Mar 2019 18:29:04 GMT

They are both actually strings. I am trying to move a string to a string. I have definitely narrowed it down to this translation, because if I just put in default text in that field to test it, it runs the job with no errors. I have confirmed, both fields in the input and the output are strings. Strange behavior.

Re: tMap conditional formula

akumar2301 — Wed, 06 Mar 2019 18:50:41 GMT

Can you print field1 and field2 as separate cols and check no error their.

Re: tMap conditional formula

Anonymous — Thu, 07 Mar 2019 04:31:22 GMT

Hi,

Could you please share the screen shots of the job flow, problematic component and schema details?

Please also share the target DB. It should be something minor. Once we see the flow, we will get better idea.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tMap conditional formula

Anonymous — Thu, 07 Mar 2019 14:29:37 GMT

@ksingh @nthampi @uganesh Thank you all for your help!

I made a few adjustments and got it to work. Here is the final expression I used:

row1.NAME != null && row1.NAME.trim().length() != 0 ? row1.NAME : row1.NUM

I really appreciate all of your input. I'm new to Talend and this is helpful. This board is great. I will be now be a longtime user.

Re: tMap conditional formula

akumar2301 — Thu, 07 Mar 2019 14:52:10 GMT

Weird But Good.

Re: tMap conditional formula

Anonymous — Thu, 07 Mar 2019 14:54:29 GMT

@steeld95 Oh Am almost close, thanks for updating the result