Congratulations on completing Exercise 4!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
Had to get help from the solution but I was on the right track! I keep getting my steps out of order when trying to put what my brain is telling me to on the canvas!
Solution
my solution
Practice Exercise 4
w/concate distinct tool
My Solution
.
My solution
here
PracticeExercise 4
solution
Submitting PE 4. TBH Don't know why do we need to combine product files? Product Categories pretty much contains enough info for result! Just combined cause of instruction!
This one was tricky, attached you find the solutions to Exercise 4!
Looks like I was focused on using the Find and Replace tool over the Join tool, but other than that it's pretty similar to the solution provided.
Cheers!
Practice Exercise 4 Solution
This was difficult given there were so many ways this could have been solved.
SOLUTION
Exercise 4 solution:
Exercise 4
Submitted
Practise Solution 4
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
Exercise 4 solution
PLA my attempt
