Nathan (@datanath) 's Twitter Profile
Nathan

@datanath

Data Engineer - @infolabuk | @alteryx ACE, London UG leader & community top contributor | @Databasyx co-founder

ID: 1414662822722691080

linkhttps://www.youtube.com/channel/UCeR8aX0JKHwWzJqRK4OLTCQ calendar_today12-07-2021 19:08:00

148 Tweet

199 Followers

193 Following

Nathan (@datanath) 's Twitter Profile Photo

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!

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!
Nathan (@datanath) 's Twitter Profile Photo

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…

Finally got round to posting a new <a href="/alteryx/">Alteryx</a> #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…
Databasyx (@databasyx) 's Twitter Profile Photo

🚨 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…

Nathan (@datanath) 's Twitter Profile Photo

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!

Day 1 of the #adventofcode2023 completed using <a href="/alteryx/">Alteryx</a> 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!
Nathan (@datanath) 's Twitter Profile Photo

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!).

Days 2 &amp; 3 of #adventofcode2023 done using <a href="/alteryx/">Alteryx</a> 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!).
Nathan (@datanath) 's Twitter Profile Photo

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 4 of #adventofcode2023 completed in <a href="/alteryx/">Alteryx</a> 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).
Nathan (@datanath) 's Twitter Profile Photo

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).

Day 6 of #adventofcode2023 completed using <a href="/alteryx/">Alteryx</a> 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).
Nathan (@datanath) 's Twitter Profile Photo

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…

Nathan (@datanath) 's Twitter Profile Photo

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.)

Day 7 of the #adventofcode2023 done and dusted in <a href="/alteryx/">Alteryx</a> Designer! A fun challenge, part 2 was interesting to think about!

(Spoiler added to hide workflow.)
Nathan (@datanath) 's Twitter Profile Photo

#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).

#adventofcode2023 Day 11 completed, once again using <a href="/alteryx/">Alteryx</a> Designer! These are starting to get pretty spicy now... Need to catch up on yesterday's still!

(Spoiler added to hide workflow).
Nathan (@datanath) 's Twitter Profile Photo

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).

Caught up with #adventofcode2023 day 10 in <a href="/alteryx/">Alteryx</a> Designer! Really loving these grid challenges but boy are they a mental workout.

(Spoiler added to hide workflows).
Nathan (@datanath) 's Twitter Profile Photo

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

Slowed right up on the #adventofcode2023 but was great to go back over and complete Day 15!

(Spoilers added to hide workflow).
Nathan (@datanath) 's Twitter Profile Photo

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! 🚀

Nathan (@datanath) 's Twitter Profile Photo

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…