If Statements in Script

[shakeeb_mohammed]

Hi,

Can someone help me with my script please.

Example data -

Supplier	PlannedQty	ActualQty
Supplier 1	80	80
Supplier 1	85	85
Supplier 2	26	26
Supplier 3	30	30
Supplier 3	50	50

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!

[sunny_talwar · Accepted solution]

May be this

If(PlannedQty <= 26, 'Pallet',

     If(PlannedQty < 80, 'Dollies', 'Tray')) as ShipmentDescription