1 Reply Latest reply: Mar 5, 2013 10:27 AM by Gysbert Wassenaar RSS

    IF function syntax

    Adotey Kwame

      Hi,

       

      The field 'class' has AAA and EAA, i would want to classify the records into ACCIDENT or ENGINEERING.

       

      The syntax below didnot work. Please help

       

      load *,

       

      IF(LEFT(class,1)='A','ACCIDENT'),

      IF(LEFT(class,1)='E','ENGINEERING') as Class_Name,