Top 20 customers based on total purchases.
Tools Used: Input, Sort, Sample, Browse
Samples
Basic - Summarize.yxmd
To summarize the schools data to find out how many schools are in each locale, and number of schools by type and level.
Tools Used: Input, Sort, Summarize, Select, Browse
Basic - MergeTwoFilesIntoOne.yxmd
To merge two different files of different spatial file types into one file, while assigning a unique identifier to each record.
Tools Used: Input, Union, Record ID, Browse
Basic - JoinMultiple.yxmd
To create a resultant stream of data that combines multiple Pet Store data tables streams.
Tools Used: Input, Join Multiple, Browse
Basic - InputFlatFile.yxmd
To input a Flat File into Alteryx for processing.
Tools Used: Input, Filter, Browse
Basic - ExtractDataChangeCase.yxmd
Extract data from a field and change the field's case.
Tools Used: Input, Formula, Browse
Basic - CreateCoverageAreas.yxmd
Create coverage areas based on a grouping field.
Tools Used: Input, Formula, Join, Sort, Summarize, Browse
Basic - AvgSalesByCounty.yxmd
Determine the Average and Aggregate purchase data per county from a customer file.
Tools Used: Input, Formula, Summarize, Select, Browse
Basic - AppendLeadingZeros.yxmd
Append leading zeros to a ZIP Code field.
Tools Used: Input, Formula, Browse
Advanced - CountyDenOverTime.yxmd
Identify the top 10 Fastest Growing Counties, based on % Annual Growth over the last 15 years and projected 5 year growth.
Tools Used: Input, Tile, Join, Filter, Formula, Sort, Sample, Browse
Pages
Latest modules
Custom reporting - Different headers with a standard footer
25 Jan 2012 - For custom reporting - Create custom headers per report with logos and match to a standard report footer.
Consuming compressed data in Alteryx
18 Jan 2012 - This module pulls data from the web unzips it and processes it.
Tip of the day
Changing field type
You can change a field's type in a number of different tools, but none is easier or more efficient than the Select tool or any tool with an embedded select.
Cool samples
Advanced - DynamicReplace.yxmd
This module demonstrates how to replace Income values across multiple fields with a code that represents a range of values. Tools Used: Text Input, Field Info, Filter, Append Fields, Formula,, Select, Sort, Dynamic Replace, Browse
