Challenge #145: SANTALYTICS 2018 - Part 1

[Emil_Kos]

Hi,

Sharing my solution. I have downloaded the data and made some changes in the separate workflow. Thanks to that I could limit number of the rows and speed up the building process.

Spoiler

[Jonathan-Sherman]

I've been practicing prescriptive tools recently and thought i'd have a go at solving the question using the optimization tool! (yes i know i've over complicated it - but why not sometimes!)

Workflow:

Spoiler

Charity Chosen:

Spoiler

[ehughes]

My solution 

Spoiler

 

[bmcclelland46]

For whatever reason the text file took forever to blend so I bit the bullet and did a nasty crosstab that took 7 minutes then just saved as an alteryx dbase. No run took more than 7 seconds after that. Container has the data processing and the bottom bit actually solved the question. Fun data crunching.

Spoiler

[JennyMartin]

Spoiler

Fun challenge!

[johnemery]

My answer is different than many others. Doing some digging, it seems that my list of charities doesn't include what many of the first posters answered with. I guess it changed.

Spoiler

[JethroChen]

Spoiler

[WernerE]

Thanks

[AryCardoso]

Done!

[A2H]

Spoiler