analyze the dataset & and let me know your perspective/ point of view
Shipment Number | Load Number | SCAC | Origin ID | Origin Name | Origin Address | Origin City | Origin State | Origin Zip | Destination ID | Destination Name | Destination Address | Destination City | Destination State | Destination Zip | Scheduled Pickup Date | Actual Pickup Date | Scheduled Delivery Date | Actual Delivery Date | Weight | Qty | Volume | Asset | Shipment Create Date | Region | Actual Pickup Arrival | Actual Delivery Arrival | Business Unit | Charge Code | Activity Number | Week Ending | Month | Load Count | UnconsolMiles | Late Reason Code | Late Master Code | LoadPlan Miles | Mode | Hours | MB | MBGroup | SHIPMENT_STATUS | WORK_TYPE | PICKUP_STOP | DELIVERY_STOP | FREIGHT_TYPE |
SHL530268 | 778993937 | AELA | 20006270 | TUBOSCOPE SOUTH | 9015 SHELDON RD | HOUSTON | TX | 77049 | 10001000 | C PORT 2 | 180 1ST ST | PORT FOURCHON | LA | 70357 | 10/01/2018 07:00 | 10/01/2018 11:05 | 10/01/2018 18:00 | 10/01/2018 20:29 | 36000 | 10 | TRANSOCEAN PONTUS | 09/26/2018 14:39 | GOM | 10/01/2018 07:41 | 10/01/2018 19:49 | Drilling | 70489785 | 3101 | 10/7/2018 | 10/1/2018 | 1 | 370 | Previous Stop | SHIPPER | 370 | 48 FT FLATBED | 13 | 370 | 350+ | DELIVERED | Drill Pipe Delivery | 1 | 99 | FREIGHT | |
SHL530271 | 778993938 | AELA | 20006270 | TUBOSCOPE SOUTH | 9015 SHELDON RD | HOUSTON | TX | 77049 | 10001000 | C PORT 2 | 180 1ST ST | PORT FOURCHON | LA | 70357 | 10/01/2018 07:00 | 10/01/2018 10:32 | 10/01/2018 19:00 | 10/01/2018 22:55 | 36000 | 10 | TRANSOCEAN PONTUS | 09/26/2018 14:39 | GOM | 10/01/2018 07:00 | 10/01/2018 18:18 | Drilling | 70489785 | 3101 | 10/7/2018 | 10/1/2018 | 1 | 370 | Previous Stop | SHIPPER | 370 | 48 FT FLATBED | 16 | 370 | 350+ | DELIVERED | Drill Pipe Delivery | 1 | 99 | FREIGHT |
Sol:
parcel is being sent from one source to another destination
here shipment numbers are unique . and load numbers are also unique
YOu can get the distinct count of the shipment numbers.
For shipment number SHL530268,origin state TX and destination state LA.
Asset is TRANSOCEAN POINTUSWO
Work type is Drill pipe delivery
10 units are sent and weight is 36000
370 miles travelled
there is a delay in arrival of 13 hrs and is due to previous stop.
Delivered data is jan 1 2018.
PICKUP_STOP | DELIVERY_STOP |
1 | 99 |
mode is by freight
analyze the dataset & and let me know your perspective/ point of view Shipment Number Load...