Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached
A quick fun one, and a great way to highlight a super useful string function! In my day-to-day work, I use this one all of the time to get the nth character from the end of a string.
Here's my solution:
I was thinking for a while how to approach this problem even considered an iterative macro (to cut off first and last letter and compare etc..). Then just for fun I checked what functions are available in alteryx - and the problem suddenly became very easy (hint hint)! That's the power of Alteryx I guess!
My solution.
Here is a not so unique solution.