General Discussions
Discuss any topics that are not product-specific here.
They're definitely starting to ramp up. Had a lot of fun with this one.
Parsed out each character into a column with regex. Transposed and took the mode of each column (Gamma). Took the opposite of the mode to get Epsilon. Used bin to int to get the numbers.
Challenge 2:
Built an iterative macro to loop through each column of characters. Used a join as a filter for identified modes. I got tripped up by the if the same amount of 0s and 1s piece, so built in a test in the macro to solve it.
Workflow:
Day 3 Macro:
Note to self: Must not make assumptions!
Macro:
The macro essentially follows the same process as the main workflow to identify the most common value (1,0) at each bit position, but uses a substring expression to move along the string to find that iterations' most common value and then filters it out. Repeating the pattern until there is only one row left and converts to int.
It was handy to recall the BinToInt() function from previous years otherwise I would have manually converted things like 10100 to 20!
I will admit the solutions that got me the stars was not my best work... but I went back after the fact and cleaned it all up with a much more straightforward solution that was actually very similar to @bflick !
I'm far too mortified of my first solution to post it here, so this is the nicely cleaned up version after I had time to think through a better strategy.
And the macro to do the Part 2 part (I had two separate macros the first time, since I didn't want to waste time figuring out how to get the same iterative macro to do both the CO2 Scrubber part and the Oxygen Generator part... happy to say I did find a way to do so eventually!) Oxygen Generator does the same thing as CO2 Scrubber section, just for the alternate column.
I'm sensing a binary theme so far this year? Definitely getting more traction out of all these sweet binary formulas in Alteryx than I have EVER used them before!!
Cheers!
NJ
