topic Re: If then else expression in Tmap : ERROR in Talend Studio

If then else expression in Tmap : ERROR

Anonymous — Tue, 12 Mar 2019 16:48:28 GMT

Hello,

I've search this forum for 2 days to get the syntax for my variable down.

When launching my job however, my tmap is in error.

My expression:

(in_row.ColumnA.equals ("YES") && in_row.ColumnB("NO")) ? "1":
(in_row.ColumnA.equals("NO") && in_row.ColumnB.equals("YES"))? "2": ""

ColumnA and ColumnB are string. And I want to create a new out column that has 3 values depending on columnA and columnB values: 1, 2 or empty.

Can someone give me any pointers on how to proceed from here ?

Thank you in advance!

Re: If then else expression in Tmap : ERROR

Anonymous — Tue, 12 Mar 2019 17:30:09 GMT

initially check either columnA or columnB not equal to null. As we don't want both nulls in two columns

then

write this expression as per your requirement

(in_row.ColumnA.equals ("YES") && in_row.ColumnB("NO")) ? "1":

"2"

Re: If then else expression in Tmap : ERROR

Anonymous — Tue, 12 Mar 2019 17:31:29 GMT

Adding to that am assuming in columns a and column b we have only yes, no and null, Please confirm it

Re: If then else expression in Tmap : ERROR

Anonymous — Tue, 12 Mar 2019 18:21:07 GMT

Yes , the values in those columns are either yes, no or null

Re: If then else expression in Tmap : ERROR

Anonymous — Tue, 12 Mar 2019 18:33:13 GMT

Then you will have mutiple combinations

ColumnA ColumnB

null yes

yes null

null no

no null

no yes

yes no

no no

yes yes

Even if you want to populate only the value for your chosen combination before as below, you should one particular value with string you chosen its an empty string which is fine, but you should check the condition columnA or columnB not equal to null, that means both not equal to null , but its not required if you want to use a specific combination as below you can set all values to empty string

(in_row.ColumnA.equals ("YES") && in_row.ColumnB("NO")) ? "1":
(in_row.ColumnA.equals("NO") && in_row.ColumnB.equals("YES"))? "2"

But use below

function , you did not write in_row.columnB.equals("No") may be that caused problem

But

use below function

(in_row.ColumnA.equalsIgnoreCase("YES") && in_row.ColumnB.equalsIgnoreCase ("NO")) ? "1":
(in_row.ColumnA.equalsIgnoreCase("NO") && in_row.ColumnB.equalsIgnoreCase("YES"))? "2"

Please give kudos if it solves your issue and accept as solution

Re: If then else expression in Tmap : ERROR

akumar2301 — Tue, 12 Mar 2019 21:11:49 GMT

I agree with Manish. Just To avoid null pointer

Use (“yes”).equalIgnoreCase(row1....)

Instead of
in_row.ColumnA.equalsIgnoreCase("YES")

In this case if any of two column is null , output will be “”

Re: If then else expression in Tmap : ERROR

Anonymous — Tue, 12 Mar 2019 21:14:23 GMT

Yes, Always we should eye to avoid null pointer exception @uganesh

Re: If then else expression in Tmap : ERROR

Anonymous — Wed, 13 Mar 2019 13:43:53 GMT

I am currently testing this expression.

Crossing my fingers it works..

Re: If then else expression in Tmap : ERROR

akumar2301 — Fri, 15 Mar 2019 16:14:09 GMT

If it worked , please make this topic as resolved. It helps others.