topic Re: Nested if Calculation in Talend Studio

Nested if Calculation

Anonymous — Thu, 16 Feb 2017 10:01:30 GMT

Hi All,

I am trying to do Nested IF in Tmap but due to some reason its throwing Error. How to fix this issue in tmap here is my condition and
error
Var.AusValidNo ==true && Var.LenforAusValidNo = 9 ? row3.cli_mobile:
Var.AusValidNo ==false && Var.LenforAusValidNo <9 ? "":
Var.ValidLandLine==true && Var.LenforAusValidNo = 9?"":
Var.ValidLandLine==false && Var.LenforAusValidNo <9?"":row3.cli_mobile

Re: Nested if Calculation

TRF — Thu, 16 Feb 2017 10:21:41 GMT

You need to change "=" by "==" for evaluation.
However, you cannot mixe different datatypes in ternary evaluation (you have boolean, string and integer)

Re: Nested if Calculation

Anonymous — Thu, 16 Feb 2017 10:31:47 GMT

I tried to use like this at that time its throwing multiple error "=="
if cant use multiple datatype for filtering condition using ternary operator in tmap
then how can i write the condition and bring my desired output

Re: Nested if Calculation

TRF — Thu, 16 Feb 2017 11:09:46 GMT

How are defined the variables? Can your share the tMap?
Independently of my previous post (I'm not completly sure) you should write like this

(Var.AusValidNo && Var.LenforAusValidNo == 9) ? row3.cli_mobile :[size=1][font=Verdana, Helvetica, Arial, sans-serif][/font][/size]
   (!Var.AusValidNo && Var.LenforAusValidNo < 9) ? "" :[size=1][font=Verdana, Helvetica, Arial, sans-serif][/font][/size]
      (Var.ValidLandLine && Var.LenforAusValidNo == 9) ? "" :[size=1][font=Verdana, Helvetica, Arial, sans-serif][/font][/size]
         (!Var.ValidLandLine && Var.LenforAusValidNo < 9) ? "" : row3.cli_mobile

What appens now?