Challenge #8: Aggregate Consumer Purchases

[Jeune]

Proposed solution

Spoiler!

[AndrewPowell]

Spoiler

 Interesting one, found the use of the summarize tool with concatenate to be useful to put all the meal item types on one line and then a bit of formula logic to return 1 for meal deals and 0 for not meant I could summarize again to get the needed values

[jonathanwillis]

Here's my solution

[YuriTchong]

I definitely learned a couple of thing.

[achank1ns]

Here's my solution.

[sreekanthac]

Hello Community,

I am bit confused with this challenge. Since my output was not matching the provided output, I checked the solution provided  and realised that the approach was slightly different. If I understood the challenge correctly (as per the wordings), the accepted categories of food are (Pizza OR Burger) AND a Side AND Drink.

So according to me the possible combinations are:

Burger, Side, Drink

Pizza, Side, Drink

Burger, Pizza, Side, Drink

Please correct me if I am wrong. Thanks in advance for your response.

---

offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger.

since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.

[sreekanthac]

Hello, 

PFA my solution. 

Spoiler

[emjiang]

i use Regex not lookup table to find the food/drink match

Spoiler

[Robinvm]

Challenge 8

[GarthTurner]

My solution