Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI'd like to try this again applying a macro.
Fun
Fun challenge, went with the iterative macro approach for the bonus.
@patrick_digan
Nice challenge.
My solution is long, looking at it I think I know nothing about alteryx. But after creating this solution I understood following things (which will help me shorten it):
1. Tonumber() function
2. RegEx Tokenize
3. Using formula in filter
However, I am still posting the original solution, the longer version.