let
    Source = Excel.Workbook(File.Contents("D:\Buckwell\AlliedServices\Datasets\TruckData\Delivery truck trip data.xlsx"), null, true),
    #"VTS Data 280820_Sheet" = Source{[Item="VTS Data 280820",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"VTS Data 280820_Sheet", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"GpsProvider", type text}, {"BookingID", type text}, {"Market/Regular ", type text}, {"BookingID_Date", type datetime}, {"vehicle_no", type text}, {"Origin_Location", type text}, {"Destination_Location", type text}, {"Org_lat_lon", type text}, {"Des_lat_lon", type text}, {"Data_Ping_time", type datetime}, {"Planned_ETA", type datetime}, {"Current_Location", type text}, {"DestinationLocation", type text}, {"actual_eta", type datetime}, {"Curr_lat", type number}, {"Curr_lon", type number}, {"ontime", type text}, {"delay", type text}, {"OriginLocation_Code", type text}, {"DestinationLocation_Code", type text}, {"trip_start_date", type datetime}, {"trip_end_date", type any}, {"TRANSPORTATION_DISTANCE_IN_KM", type number}, {"vehicleType", type text}, {"Minimum_kms_to_be_covered_in_a_day", type any}, {"Driver_Name", type text}, {"Driver_MobileNo", type any}, {"customerID", type text}, {"customerNameCode", type text}, {"supplierID", type any}, {"supplierNameCode", type text}, {"Material Shipped", type text}})
in
    #"Changed Type"