This weekly challenge gets the user to build out a moving average over two different periods. Follow along with this challenge to learn how the multi row formula tool can be used to calculate moving ...
In Alteryx it is not possible to do conditional joins like you can is SQL. Therefore to solve this weekly challenge you need to generate data to join the customers to the sales person data. ...
A common requirement is to get the post code (zip code for the US readers) from an address. When the address fields are concatenated into a single row of data the post code, while being ...
Use Case: You’ve got lots of fields where that data is in the same format, but you want to quickly make a variety of changes to that data, but it’s tiresome needing to go through ...
This post sets out three different ways to change the behaviour of a tool container using a radio button in the app interface. The use case for this is with analytic apps where depending on ...
In my second post in the three ways to do something in Alteryx series, I take a look at how to update a value in a batch macro. For those who are not familiar, batch ...
Where are my customers and are they unique to my brand or is there overlap with a competitor? To answer this question we need geospatial data about our stores, our competitors and where the customers ...
In the third part of the three ways series, I am going to demonstrate three ways to update a date in a filter (the same technique also applies for other tools like a formula tool). ...
In our 3rd AlterTricks podcast we talk with the amazingly well known and internationally renown Alteryx Ace James Dunkerly. We talk in depth about his Alteryx start as well as his perspectives on such topics ...
In this episode Chris and Joshua talk about Design Patterns and why they are important for users to learn, as they make the data transformation: Effective – the design pattern will work for 20 to ...