topic Re: How to return multiple columns value with if condition in Talend Studio

How to return multiple columns value with if condition

Anonymous — Mon, 29 Jan 2018 11:52:45 GMT

Hello all,

How to return multiple column values with if condition?

Currently I wrote like below and it is giving me error.

The logic is subscriber info is null then return SP_SERV_ID, SITE_A_ID AND SUB_ACCOUNT field values.

row1.SUBSCRIBER == null ? row1.SP_SERV_ID, row1.SITE_A_ID, row2.Sub_Account
: null

Any help is much appreciated.

Re: How to return multiple columns value with if condition

Anonymous — Mon, 29 Jan 2018 12:25:13 GMT

What exactly are you trying to do? It looks like you are trying to actually apply logic to returning a row based on a column values. This can be done using the filtering in a tMap component. Can you give a bit more information on this. There will be a way of doing this, but we need a bit more info.

Re: How to return multiple columns value with if condition

Anonymous — Mon, 29 Jan 2018 12:31:42 GMT

Hello,

Thanks for the response.

Here is what I am trying to achieve.

row1.SUBSCRIBER == null ? row1.SP_SERV_ID ||
row1.SUBSCRIBER == null ? row1.SITE_A_ID ||
row1.SUBSCRIBER == null ? row2.Sub_Account
: null

When I tested this I get below error,

Exception in thread "main" java.lang.Error: Unresolved compilation problems:

Requirement:

If Subscriber is null then return serv_id, site_a_Id, sub_account

else Null

Regards,
Deepak

Re: How to return multiple columns value with if condition

TRF — Mon, 29 Jan 2018 12:38:36 GMT

Hi,

What do you want to do?

Do you want to concatenate SP_SERV_ID, SITE_A_ID and Sub_Account?

In this case, try this:

row1.SUBSCRIBER == null ? row1.SP_SERV_ID + row1.SITE_A_ID + row2.Sub_Account : null