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

    Loading IF statement

    Andros Goh



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


      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.