community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #146: SANTALYTICS 2018 - Part 2

Aurora

Late to the party(again).  But echoing @kat's sentiment, it's been a fun journey from opening Alteryx for the 1st time 10 months ago to scraping the community site and building an optimization model today.  I've worked with a lot of languages/no-code packages in my time going way back to 6510 assembly language and Alteryx is an almost perfect blend of user-friendly development environment coupled with an extremely deep tool kit that is easily extensible.  

 

Spoiler
Solution.png

 

Dan

Asteroid

My solution and shopping list

Asteroid

Hi! Here my solution :)

Alteryx Certified Partner

Only counted users who posted more than one attachment as one for total number of solutions.

 

Spoiler
challenge_146.PNG
Alteryx Partner
Spoiler
Spoiler.PNG
Aurora
Aurora

So - I went completely over the top on this one - and built a few reusable Lithium connectors - seems to have worked well.

 

Thanks to @cgoodman3 for the solution using the optimization tool - I've not used this yet!

 

Annotation 2019-06-14 133308.png

 

Spoiler

Step 1: get the solution count.    Built some reusable macros for the Lithium (community) API

Count the solutions.png

Step 2: Then filter the potential shopping list

Solution part 1.pngsolution part 2.png

Step 3: Use an iterative macro to maximize spending:

Iterator.png

Looking forward to seeing how others tackled this one!

 

Alteryx Certified Partner

My solution

 

Spoiler
I cheated and used the solution counter macro

I made and iterative macro that randomly picks items from the list until all the money is gone...total 333 items selected


Capture.PNGCaptureit.PNG