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
Error
Product SKU
RecordID
1
Int32
6
0
,
Review = if(Contains([All Product_Category], "Technology") and Contains([All Shi...
,
,
C:\Users\Lakshay.khosla\OneDrive - JLL\Desktop\TOOL\Practice Exericse 4.yxdb
False
True
False
Practice Exericse 4.yxdb
Horizontal
Practice Exercise 4