Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this
If(PlannedQty <= 26, 'Pallet',
If(PlannedQty < 80, 'Dollies', 'Tray')) as ShipmentDescription
May be this
If(PlannedQty <= 26, 'Pallet',
If(PlannedQty < 80, 'Dollies', 'Tray')) as ShipmentDescription