Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Hi @GeneR , Like a few others I got confused on the date and initially took this as >= 1st June 2013 but only because it was mentioned in 'comment' box within the "challenge_8_start_file". I did it slightly different to the solution but like most things there's always a few different paths we can take.
I thought I'd add a bit extra just to count the actual number of meal deals that would have been sold - just for curiosity.
I think my solution is bit long. I just completed Core designer certification in first go and was applying my learning to solve this challenge. Here are the steps I've followed -
- Data cleansing of Look up table. Since Join is case sensitive, I converted the columns to upper case to have uniformity across the flow.
- Parsed Date column in POS table to date format, Filtered records with date > 2013-06-01, converted the case to upper to make it compatible with join.
- Joined both these tables to fetch the type of ordered item, Replacing 'PIZZA' and 'BURGER' with 'FOOD' to satisfy the problem statement.
- Cross tab tool to get the count of each type of food for a ticket, Getting total ticket count in a separate data stream as 'Total Count', Filtering the cross tab output with given condition, Getting ticket id count as 'Potential Meal deal' from the true anchor of the filter.
- Joining the 2 data stream by position, applying percentage formula to get the output.
Workflow completed in 4 seconds!
