Line Item Categories
Line Item Details
Payment Methods
Initial State
Practice Exercise 4
Use the Payment Methods table to add Shipping Methods as a column to "Start 4.1". Combine the "Line Item Details" and "Line Item Categories" information. Finally flag all transactions with unknown vendors ("N/A") that were paid "Direct Deposit".
Associate the appropriate "Payment Method" with each transaction based on its "Urgency".
Then combine the "Line Item Categories" information with the "Line Item Details" info (the headers in Line Item Details are product SKUs).
Finally, combine both datastreams to flag all transactions which contained unknown vendors (input as "N/A") and were paid via "Direct Deposit". Mark those orders with "REVIEW" and all others with null.
Final State
Not Specified
Check
Low
Check
Medium
Direct Deposit
High
Direct Deposit
Critical
Wire Transfer
Start 4.1.yxdb
Start 4.1.yxdb
Line_Item_Categories.yxdb
Line_Item_Categories.yxdb
Line_Item_Details.yxdb
Line_Item_Details.yxdb
Final State - Exercise 4.yxdb
Final State - Exercise 4.yxdb
Line_Item_ID
Warn
,
Urgency
Priority
Transfer Method
FindAny
Append
C:\Users\dario\AppData\Local\Temp\Engine_6952_fe6350b2f40e4633be793cf9a514ae54_\Engine_1292_5a7f5a3346d94292b6b5d7568f05e83c_.yxdb
Single
Profile
C:\Users\dario\AppData\Local\Temp\Engine_6952_fe6350b2f40e4633be793cf9a514ae54_\Engine_1292_1a91174c890849b5bb2092121bb7b96f_.yxdb
Single
Profile
,
,
Review = IF Contains([Vendor], "N/A") AND Contains([Transfer Method], "Direct") ...
Horizontal
Solution Practice Exercise 4