Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi,
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.
My solution
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.
Fun challenge!
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.