We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
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
This one took me longer than i'm proud to admit. But, it was very rewarding to finally work it out!
Hmm. Some interesting solutions. l went a little avant garde. I created a table of values for the alphabet and then fed that into the data stream. A few extra steps but I got there.
Fun challenge! I first tried using REGEX but quickly realized it wouldn't work easily. Decided to just check each letter in word2 that matches word1 and replace with a '-' if matches. Then checked which ones ended up with all '-' and correct # of letters. Not sure if this was most efficient, but it worked. Might be good candidate for a batch macro 🙂
