Initial State Shipping Methods Product Categories Product Details Practice Exercise 4 Use the Shipping Methods table to add Shipping Methods as a column to "Start 4.1". Combine the "Product Details" and "Product Categories" information. Finally flag all orders containing "Technology" items that were shipped "Freight". Associate the appropriate "Shipping Method" with each order based on its "Order_Priority". Then combine the "Product Categories" information with the "Product Details" info (the headers in Product Details are product SKUs). Finally, combine both datastreams to flag all orders which contained "Technology" items and were sent via "Freight". Mark those orders with "REVIEW" and all others with null. Final State Product Categories.yxdb Product Categories.yxdb Not Specified Freight Low Ground Medium 2 Day High Next Day Air Critical Same Day Start 4.1.yxdb Start 4.1.yxdb Product Details.yxdb Product Details.yxdb Final State - Exercise 4.yxdb Final State - Exercise 4.yxdb Warn Product SKU Last Product SKU Warn !IsNull([Value]) Simple IsNotNull Value True fixed 2019-10-11 08:56:00 0 2019-10-11 08:56:00 2019-10-11 08:56:00 !IsNull([Value]) [Info Category] = "Product_Container" Simple = Info Category True fixed 2019-10-11 09:01:02 0 Product_Container 2019-10-11 09:01:02 2019-10-11 09:01:02 [Info Category] = "Product_Container" Review = IF Contains([All Product Categories], "Technology") AND Contains([All S... , , Horizontal Practice Exercise 4
