Advent of Code 2021 Day 4 (BaseA Style)

[jdunkerley79]

Discussion thread for day 4 of the Advent of Code - https://adventofcode.com/2021/day/4

[estherb47]

Thanks, @joshbennett ! I love how we learn from each other in this space

[OllieClarke]

Catching up on the weekend 😬

Spoiler

WorkflowFirst PartSecond Part

[SeanAdams]

This was a fun one - these challenges where you have to look for patterns on a board intrigue me.

Spoiler

First part is fairly simple - data import and shaping:

Then call the built-in Alteryx Bingo Macro and either find the last or the first board.

The Bingo Macro is relatively simple - it passes the board through multiple times, marking the cells as done by using YXDB file - then use the list of bingo balls as the iterator

Then the final piece is the scoring macro - super easy:

[SeanAdams]

This is an elegant solution @AkimasaKajitani - thank you, it gave me something to learn.

[glenperes]

Spoiler

Managed to do it without an iterative macro

 

[caitlynmcintyre]

This one was tough for me because I really confused myself with a stupid mistake, but got there in the end.

Spoiler

My problem was my part 2 macro was telling me which card would win last, not when it would win. I just pushed that card number into my Part 1 macro to get the answer instead of fixing my mistake 🙈

Macro to show first card/which number will give bingo 

Macro that gives last card left