Can someone help me with my script please.
Example data -
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!
May be this
If(PlannedQty <= 26, 'Pallet',
If(PlannedQty < 80, 'Dollies', 'Tray')) as ShipmentDescription
View solution in original post