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

    If Statements in Script

    Shakeeb Mohammed



      Can someone help me with my script please.


      Example data -

      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!