6 Replies Latest reply: Apr 1, 2016 4:41 PM by Satish Kurra RSS

    Loading IF statement

    Andros Goh

      Hi,

       

      I am struggling with the loading script using IF below, appreciate anyone's help :

       


      [TCODE]:
      LOAD fileNumber

      if(([trackCode]='BOOKED') AND [TransportMode]={'B','V'}) as TB
      if(([trackCode]='BOOKCONF) AND [TransportMode]={'P','T'}) as TD
      resident [Shipment];

       

      The shipment already has trackCode and TransportMode fields, the problem is the syntax error.

      Thank you.

       

      Regards,

      AG