topic How to use If and Set in Talend in Talend Studio

How to use If and Set in Talend

Anonymous — Thu, 18 Jan 2018 09:54:35 GMT

Hi Folks,

I am new to Talend.

I am looking for functionality to execute the workflow.

Here is what I need,

If my input variable 1 is 'Usage' and my input variable 2 is blank then I want to set Input variable 2 as 'String'

How to achieve this?

Regards,

Deepak

Re: How to use If and Set in Talend

TRF — Thu, 18 Jan 2018 10:49:49 GMT

Hi,

In tMap, you may try this expression on the output side for the field associated to "variable2":

row1.variable1 != null && 
row1.variable1.equalsIgnoreCase("Usage") && 
(row1.variable2 == null || row1.variable2.equals("")) ? "String" : row1.variable2

Hope this helps.

Re: How to use If and Set in Talend

Anonymous — Thu, 18 Jan 2018 11:09:27 GMT

Thanks it worked

Re: How to use If and Set in Talend

TRF — Thu, 18 Jan 2018 13:10:20 GMT

Great!
Don't forget to mark this case as solved (Kudos also accepted).