This weekly challenge takes a look at creating unique combinations. This is a common requirement when you append many similar fields together. Chris provides a walkthrough of this weekly challenge, which not only is built ...
Every come across a dataset where there are a mixture of date formats used, such as dd-MM-yyyy, yyyy/MM/dd, MM-dd-yyyy? Using regex to solve for this by spotting patterns in the text could be the answer. ...
However you use Alteryx, it is likely that you will need to work with delimited text files. This is a core skill you will need to be able to parse the data into the relevant ...
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. ...
This weekly challenge makes use of a spatial function in the summarise tool. The challenge as set out on the Alteryx Community asks users to find the mid-point for each region there is an Alteryx ...
