Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #8: Aggregate Consumer Purchases

Highlighted
Alteryx
Alteryx

Solution attached.

Highlighted
8 - Asteroid

For data joining I like to use the "FindReplace" tool where you can use "append" instead of "replace" to match 2 data sources.

Highlighted
8 - Asteroid

I recognized that the Inputdata is missing in my uploaded file.

 

2 questions here:

- how can I change/update an existing post from myself?

- I tried to attach into a new post the .yxzb file but got the error message: wrong file Format. How can I upload this format?

 

Highlighted
14 - Magnetar
14 - Magnetar

Solution, nothing earth-shatteringly different from the others on this one. :)

 

Spoiler
WeeklyChallenge8.JPG
Highlighted
Alteryx Certified Partner

Here is my solution to challenge #8.

 

Spoiler
challenge8.jpg
Highlighted
6 - Meteoroid

Its a simple but interesting problem because doing it in the alteryx framework , makes it interesting.

Highlighted
14 - Magnetar
14 - Magnetar

my numbers are slightly different, but I'm guessing that's because I used a date filter after May 31.

Highlighted
6 - Meteoroid

I seem to have approached it slightly different than others.

 

Spoiler
Wk 8.JPG
Highlighted
8 - Asteroid

May not have been the cleanest approach, but here's my solution

Spoiler
Week8SolutionPicture.png
Alteryx Certified Partner
A word of caution when using Append, this generally the slowest method as you creating a Cartesian join, which requires computational grunt. Sometimes it can't be avoided, and it's very easy to write, but if you are spending many to many it may not be the best method.