1 Reply Latest reply: Jul 25, 2018 11:03 AM by Sunny Talwar RSS

    If Statements in Script

    Shakeeb Mohammed

      Hi,

       

      Can someone help me with my script please.

       

      Example data -

      SupplierPlannedQtyActualQty
      Supplier 18080
      Supplier 18585
      Supplier 22626
      Supplier 33030
      Supplier 35050

       

       

      What I want to do in my script is to add a column in my QVD file as below -

       

      IF PlannedQty >= 80 as Tray

      IF PlannedQty <= 26 as Pallet

      IF PlannedQty is > 26 and < 80 as Dollies

       

      I then want to put Tray, Pallet and Dollies as ShipmentDescription.

       

      #Thanks in advance!