Advent of Code 2022 Day 6 (BaseA Style)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Discussion thread for day 6 of the Advent of Code - https://adventofcode.com/2022/day/6
- Labels:
- Advent of Code
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Build to scale and you'll never fail
Learned my lessons from last year, when in doubt make everything into rows.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I used a long formula for the first part knowing it wouldn't work for more than four letters. Naturally, the second part involved more letters 😂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My take on this using 4 tools and string functions
Happy Analyzing :)
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The first day I put my alarm on snooze and I over sleep by a bit so miss out on the opportunity to take on @bflick and @clmc9601 for the fastest solve.
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@cgoodman3 maybe you already did this, but Excel can help assemble the long expressions! Slightly less manual than typing them by hand.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Long way around with a Multi-Row Formula for the solve... then a quick Tool Golf refactor for 7 tools (both parts). Enjoyed the quicker run after yesterday's almost-mind-bender!
NJ
Sr. Manager, Product Management, Designer
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Slight modification to improve the tool golf score and to make it dynamic.
1) Created a user constant "StringLength" which the user can specify to modify the data, which is used in the formula and filter tools
2) Used generate rows to explode the input into many rows
3) Used substring to walk along the input the desired number of letters
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator