usage of IF Statement

akhil

• December 25, 2012 00:00

• Answered

Follow

In the reformat component, I have created a expression as follows. But its giving a syntax error.

if isnull($in.0.ID) $in.0.ACCOUNT_NAME else $in.0.BILLING_CITY

Could you please let me know how to use the if statement correctly.

Thanks & Regards,
Akhil

• 

  admin

  • December 31, 2012 08:39

  0

  Comment actions Permalink

  Hi Akhil,
  
  please take a look on http://doc.cloveretl.com/documentation/ ... -ctl2.html and http://doc.cloveretl.com/documentation/ ... -ctl2.html
  
  In your case:
  
  

  if (isnull($in.0.ID)) $in.0.ACCOUNT_NAME; else $in.0.BILLING_CITY;

  
  
  should work. I added round brackets around condition and add semicolons for each statement. Also, you are probably missing left side of statements. So it should be something like:
  
  

  if (isnull($in.0.ID)) $out.0.MY_FIELD = $in.0.ACCOUNT_NAME; else $out.0.MY_FIELD = $in.0.BILLING_CITY;

  
  
  Or shorter:
  
  

  $out.0.MY_FIELD = isnull($in.0.ID) ? $in.0.ACCOUNT_NAME : $in.0.BILLING_CITY;

  
  
  I hope this helps.
• 

  akhil

  • December 31, 2012 10:13

  0

  Comment actions Permalink

  Thanks Jaroslav.
  
  Thanks & Regards,
  Akhil

Please sign in to leave a comment.