Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
General Discussions
Discuss any topics that are not product-specific here.
Spoiler
I am impressed with some of the regex solutions for part 2 on here. I hardcoded mine for part 2, but it took a while to find all the exceptions!
Great start to AOC - I feel like I cheated a bit, but going to have a look at how other people did it.
Spoiler
Recipe here is a bit of a cheat:
- Take each number (written in text and in numbers) in a text input. screenshot 1
- do a cross-join with the test data so that every data row joins to every number
- then check for the first instance of the number ("one") in the text
- then reverse the test data and the numbers and look for the first instance of the number ("eno" - reversed "one")
- now you have the last and the first instance of numbers in the string
Why this way?
- it avoids the issue of numbers that share letters like "oneight"
- given you only want the first and last - you don't need to worry about every instance
- Finding the first instance is easy in Alteryx, finding the last is a little tougher, so reverse the strings and then it all becomes "find the first"
Recipe here is a bit of a cheat:
- Take each number (written in text and in numbers) in a text input. screenshot 1
- do a cross-join with the test data so that every data row joins to every number
- then check for the first instance of the number ("one") in the text
- then reverse the test data and the numbers and look for the first instance of the number ("eno" - reversed "one")
- now you have the last and the first instance of numbers in the string
Why this way?
- it avoids the issue of numbers that share letters like "oneight"
- given you only want the first and last - you don't need to worry about every instance
- Finding the first instance is easy in Alteryx, finding the last is a little tougher, so reverse the strings and then it all becomes "find the first"
Complete! I borrowed @Tokimatsu's RegEx Replace after my RegEx Replace formulas missed the stupid Part 2 trick
The ReverseString idea from others was genius!
My first every AOC attempt "for real" (did one last week to go over in a UG). Didn't get to it until this afternoon, but **bleep**, that second part was a pain! Tried several things but they were hardcoded and I hated that, so I finally came up with a dynamic way using append. Fun fun!
