Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI kept thinking this should use the tile or multi-field binning tool for buckets, but finally realized it was better done with regex functions and summary tools.
KIS = keep it simple
Tried doing it with Find and Replace tool at first. Was a fun challenge
My Solution. Took me some time to get the logic right as Alteryx does not support Nested IFs (only Nested ELSEIFs but not Ifs within Then). But totally worth it.
Not the most elegant of solution but it does the trick!
Here is my submission!