Challenge #8: Aggregate Consumer Purchases

[CKent]

This challenge uses my all-time favorite feature in Alteryx!

Spoiler

The CONCAT String in the Summarize tool 🙂

[mpg222]

Spoiler

I think my logic in the comparison was a little different than the provided solution, but the result was still in the ballpark.

[David_Adesanya]

Done.

[mithily]

OK, create the date time field and filter post JUly 2013, then join to lookup to get food type, summarize by ticket id and concatenate the types so you can do a contains check for each ticket id for the categories and get the number of distinct tickets that satisfy the condition.

[AkimasaKajitani]

My solution.

Spoiler

it is need to attention to filter date.

[LukasJennings]

Spoiler

[JasonHu]

Spoiler

Here is my submission, inspired by kconner

[ShengJun1]

Solution. 

[Tokimatsu]

Solved.

Spoiler

 

[mmkisaac]

Challenge 8