Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Here is my solution. Not sure if I missed something but, got the same result 🙂 Good to see the different ways this can be approached:
Experimenting with different tools so probably why it ended up being a bit longer than the solution. The solution is definitely more optimal but I guess there is many ways to Alteryx complaints.
Spoiler
Some lessons learnt that I thought I'd share with you from my experimenting:
I noticed that the summarise tool explodes the memory of the bucket to a ridiculously large variable string. I noticed no optimisation was performed in the solution. So, I have used a select tool purely to optimise memory early. The main reason why my solution is longer is due to using split to columns and a formula tool to extract matches instead of split to rows. It would have saved me time cleaning up the commas at the end too.
I noticed that the summarise tool explodes the memory of the bucket to a ridiculously large variable string. I noticed no optimisation was performed in the solution. So, I have used a select tool purely to optimise memory early. The main reason why my solution is longer is due to using split to columns and a formula tool to extract matches instead of split to rows. It would have saved me time cleaning up the commas at the end too.
