Cloud Quest #2: Consumer Purchase Aggregation

[JeffF]

Spoiler

[MikeRoof]

👋

Spoiler

[JoachimCaronTIL]

Here is my solution with documentation :

Spoiler

 

[Shelbey]

Here's my solution. One thing to mention is that you only get the desired results from the challenge description if you don't run the job. If you do run the job, the counts increase and your final percentage is off by a fraction. If you also build this workflow in Designer, don't compare the results from each tool to each tool in your Designer Cloud workflow for the same reason :) 

Also, I'm not sure why, but I had an issue with the Formula tool. I originally had an IF THEN statement to create a flag for the potential meal deals followed by Summarize to count the number of potential meals. It worked once, then randomly stopped working and all my flags were set to 0. My solution was to replace the Formula tool with 3 Filter tools instead then a Count Rows tool.

Workflow:

Spoiler

Results:

Spoiler

Sample Results:


Complete Results:

[kelvin_law1]

Agreed that a Select All will be helpful for the Cross Tab tool.

Also, I just realized that Fixed Decimal is not a data type option in Designer Cloud.

Here is my solution:

Spoiler

[Qiu]

I like the Tool Icons better of Cloud than the ones of Desktop. 😂

Spoiler

[Jean-Balteryx]

Here is my solution !

Spoiler

[LynnPätzold]

This was also a Weekly Challenge once, wasn't it? In Alteryx Designer I would have been way faster. Still getting used to Alteryx Cloud.

Spoiler

 

[matyohan]

Here is my solution, 

Thanks for these new challenges, 

Yohan

Spoiler

 

[AlexG]

Spoiler