More #PreppinData challenges completed! 2023 weeks 5 through 8. Loving the challenge #Python is providing - Google, ChatGPT and Stack Overflow are fast becoming my best friends! Got to play around with some new functions here and personally love melt() as a name!

Finally got round to posting a new Alteryx #macro! This time, a tool that allows you to conduct flexible, SQL-like joins in Designer! Full blog on how it works coming soon. Download it here: community.alteryx.com/t5/Community-G… Find the supplementary info here: docs.google.com/document/d/1aS…

🚨 NEW BLOG LIVE! 🚨 Last week we published a new blog, outlining the inner workings of the SQL Join tool, recently released by Nathan! Check out the blog: databasyx.com/blogs/why-and-… Get the macro: community.alteryx.com/t5/Community-G… Check out the additional info: docs.google.com/document/d/1aS…

Day 1 of the #adventofcode2023 completed using Alteryx Designer! Part 2 threw a bit of a curveball but we do love the challenge! Spoiler tag added to hide the workflow if you've yet to try!

Days 2 & 3 of #adventofcode2023 done using Alteryx Designer! Some fun workflows to get these done - definitely didn't expect the co-ordinate/grid challenges to be coming out already but it's all fun and games! (Spoiler tag added so as not to ruin it for anyone!).

Day 4 of #adventofcode2023 completed in Alteryx Designer! Didn't expect to be cracking out the macros so soon but it looks like this year is already getting fairly spicy. Another nice challenge! (Spoilers added for obvious reasons).

Day 6 of #adventofcode2023 completed using Alteryx Designer and boy was this a welcome 'break'! Only managed part 1 yesterday so haven't posted that - will give it another crack at some point. (Spoiler added to hide workflow).

I released a new Alteryx tool yesterday that allows you to apply the functionality of the Text To Columns tool to multiple fields simultaneously. Feel free to check it out here! As usual, any feedback, criticism or requests are very welcome! community.alteryx.com/t5/Community-G…

Day 7 of the #adventofcode2023 done and dusted in Alteryx Designer! A fun challenge, part 2 was interesting to think about! (Spoiler added to hide workflow.)

#adventofcode2023 Day 11 completed, once again using Alteryx Designer! These are starting to get pretty spicy now... Need to catch up on yesterday's still! (Spoiler added to hide workflow).

Caught up with #adventofcode2023 day 10 in Alteryx Designer! Really loving these grid challenges but boy are they a mental workout. (Spoiler added to hide workflows).

Slowed right up on the #adventofcode2023 but was great to go back over and complete Day 15! (Spoilers added to hide workflow).

Just published my first Databasyx blog of 2024! This time detailing how you can create grouped record IDs and/or (nominal) ranks in Alteryx Designer. Feel free to check it out at the following link: databasyx.com/blogs/creating… Here's to more building and blogging this year! 🚀

Great set up in the Covent Garden Odeon for the Databricks Data & AI summit! Free popcorn and swag? Yes please! #LiveFromTheLakehouse

Recently put a couple of new #dataengineering blogs on Databasyx - feel free to check them out and let me know your thoughts! Different types of materialization in dbt Labs: databasyx.com/blogs/differen… Creating Databricks secrets with the Databricks CLI: databasyx.com/blogs/creating…