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!
