Looking to leverage Databricks secrets but not sure on how to get started? Check out this quick, informative blog on how to use the Databricks CLI to set up scopes & secrets and start using them within minutes!

Wondering what the difference is between different types of materialization when utilising dbt? Or already aware of these and wondering how to invoke them? Check out this blog to learn more!

We tend to see many of the same Formula expression errors popping up amongst Alteryx Designer users, especially those new to the software. Here’s a compilation of some of the most common and what they mean/how to fix them!

See how you can use Alteryx Designer to scaffold your data, a technique use to generate missing rows for the sake of creating certain reports and visualisations.

Read on to discover how you can set up your workflow to Render multiple named Excel sheets, rather than the standard ‘Sheet1’, ‘Sheet2’ nonsense!

We often have to verify our email when logging into online systems. Dive in to discover how you can recreate this functionality in Alteryx to help protect your applications!

Do you find yourself writing large, repetitive filter statements that are hard to follow and maintain? Check out these three techniques for making the process easier to manage and more dynamic!

Find out how you can quickly and easily assign grouped record IDs/ranks using two different approaches in Alteryx Designer!

Use workflow events in order to gather key information each time your workflows run, or alerts when they contain errors.

Read about how (and why) I built a tool in Alteryx Designer that allows you to conduct flexible, SQL-like joins without the need for blowing up your data!

We can take further steps towards automation or control in certain cases by leveraging the power of the Alteryx Server API. Read about a real life use case integrating the API with Salesforce!

Read on as we go through some of Alteryx’s reporting tools and create a basic PDF report combining multiple reporting elements.

Added as part of the 2023.1 release, in this blog we look through the brilliant new Control Container tool and how they can be leveraged to run sections of our workflow sequentially and conditionally, as well as use workflow messages as data!

Cryptic crosswords are one of my favourite hobbies at the moment, so I decided to make a workflow that could randomly create a solvable cryptic crossword at runtime using base Alteryx and the ChatGPT API!

Working with dates in Alteryx Designer requires us to use a specific, ISO-defined format. Learn how we can convert strings that represent dates in other formats into datetime fields, as well as vice-versa if we want to display dates as custom formats.

Developers can leverage the power of workflow constants within Alteryx Designer to create user-defined, global variables that can be referenced multiple times throughout a workflow, saving time and effort when these values need amending!

Using Alteryx for obscure projects is a favourite pastime of mine, so creating an app that can highlight Pascal’s triangle values if they’re divisible by an input was something I needed to do.