Why do you need to improve the batch input macro A typical first use case when teaching batch macros to Alteryx users is for the use case where the dynamic input tool produces a warning ...
Excel! This isn’t a dig at Excel, as it is really useful, but when the priority of the spreadsheet is prettiness it can be a pain for a data analyst! One common problem is users ...
Ok, this one is not strictly a design pattern, but it’s a quick and simple way to easily rename fields of an input file, to what is expected by an analytic process downstream by using ...
Have you ever come across an instant where you need to have a field where the values within it can change based on a user input. Let’s take this input dataset: Source: mockeroo.com If in ...
Are you a spreadsheet hero, but found that when you read the data into Alteryx the data doesn’t display as you would have expected? This is probably because you are using nested headers in your ...
In this Design Pattern we are going to show you how to reshape data where there are repeating fields which have the same name. This is a common structure that you may encounter when new ...
Move Fields to the Right Here is a really useful design pattern that can be used when you have either brought in data or pivoted to get data that has fields that need to be moved ...
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 ...
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 ...
