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
Product SKU
RecordID
1
Int32
6
0
Warn
,
All_products_categories = [Product_Category]+[Product_Sub-Category]
Review = if ...
,
Horizontal
Practice Exercise 4