let
    Source = Excel.Workbook(File.Contents("D:\Buckwell\AlliedServices\Datasets\DataCoSupplyChainDatasetWB.xlsx"), null, true),
    #"Allied Supply Chain_Sheet" = Source{[Item="Allied Supply Chain",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"Allied Supply Chain_Sheet", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Type", type text}, {"Days for shipping (real)", Int64.Type}, {"Days for shipment (scheduled)", Int64.Type}, {"Benefit per order", type number}, {"Sales per customer", type number}, {"Delivery Status", type text}, {"Late_delivery_risk", Int64.Type}, {"Category Id", Int64.Type}, {"Category Name", type text}, {"Customer City", type text}, {"Customer Email", type text}, {"Customer Fname", type text}, {"Customer Id", Int64.Type}, {"Customer Lname", type text}, {"Customer Password", type text}, {"Customer Segment", type text}, {"Customer State", type text}, {"Customer Street", type text}, {"Customer Zipcode", Int64.Type}, {"Department Id", Int64.Type}, {"Department Name", type text}, {"city", type text}, {"city_ascii", type text}, {"lat", type number}, {"lng", type number}, {"country", type text}, {"Order Customer Id", Int64.Type}, {"order date (DateOrders)", type datetime}, {"Order Id", Int64.Type}, {"Order Item Cardprod Id", Int64.Type}, {"Order Item Discount", type number}, {"Order Item Discount Rate", type number}, {"Order Item Id", Int64.Type}, {"Order Item Product Price", type number}, {"Order Item Profit Ratio", type number}, {"Order Item Quantity", Int64.Type}, {"Sales", type number}, {"Order Item Total", type number}, {"Order Profit Per Order", type number}, {"Order Status", type text}, {"Order Zipcode", Int64.Type}, {"Product Card Id", Int64.Type}, {"Product Category Id", Int64.Type}, {"Product Description", type any}, {"Product Image", type text}, {"Product Name", type text}, {"Product Price", type number}, {"Product Status", Int64.Type}, {"shipping date (DateOrders)", type datetime}, {"Shipping Mode", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Customer Id", "Customers"}}),
    #"Added Conditional Column" = Table.AddColumn(#"Renamed Columns", "Sector", each if [Shipping Mode] = "Standard Class" then "Agricultural Inputs" else if [Shipping Mode] = "Second Class" then "Aquaculture" else if [Shipping Mode] = "First Class" then "Livestock" else if [Shipping Mode] = "Same Day" then "Textiles & Apparel" else "Water")
in
    #"Added Conditional Column"