cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.

Tool Mastery Index

Community Content Engineer
Community Content Engineer

The Tool Mastery Series is a compilation of Knowledge Base contributions that introduce diverse working examples for Designer Tools. We've organized the links below to help you on your journey to mastering the Alteryx Designer!


In/Out

Browse.png Browse
Date Time Now.png Date Time Now
Directory.png Directory
Input Data.png Input Data
Output Data.png Output Data
Text Input.png Text Input

Preparation

Auto Field.png Auto Field
Data Cleansing.png Data Cleansing
Date Filter.png Date Filter
Filter.png Filter
Formula.png Formula
Generate Rows.png Generate Rows
Multi Field Formula.png Multi Field Formula
Multi-Row Formula.png Multi Row Formula
Record ID.png Record ID
Sample.png Sample
Select.png Select
Sort.png Sort
Tile.png Tile
Unique.png Unique

Join

Append Fields.png Append Fields
ConsumerView Matching.png ConsumerView Matching
Find Replace.png Find Replace
Fuzzy Match.png Fuzzy Match
Join.png Join
Join Multiple.png Join Multiple
Make Group.png Make Group
Union.png Union

Parse

DateTime.png DateTime
RegEx.png RegEx
Text To Columns.png Text To Columns

Transform

Arrange.png Arrange
Cross Tab.png Cross Tab
Running Total.png Running Total
Summarize.png Summarize
Transpose.png Transpose

Reporting

Charting.png Charting
Email.png Email
Image.png Image
Layout.png Layout
Render.png Render
Report Footer.png Report Footer
7649iBAA5D398313390FE Report Header
Report Map.png Report Map
Report Text.png Report Text
Table.png Table

Documentation

Comment.png Comment
Explorer Box.png Explorer Box
Tool Container.png Tool Container

Spatial

Create Points.png Create Points
7553iB0C2B4916F800D40 Distance
Spatial Info.png Spatial Info
Trade Area.png Trade Area

Interface

Action.png Action
Apps and Macros.png Apps and Macros
Check Box.png Check Box
Control Parameter.png Control Parameter
Date.png Date
Drop Down.png Drop Down
Error Message.png Error Message
Macro Input.png Macro Input
Numeric Up Down.png Numeric Up Down
Radio Button.png Radio Button

Data Investigation

Association Analysis.png Association Analysis
Basic Data Profile.png Basic Data Profile
Field Summary.png Field Summary
Histogram.png Histogram

Predictive

Decision Tree.png Decision Tree
Linear Regression.png Linear Regression
Logistic Regression.png Logistic Regression
Score.png Score
Test of Means.png Test of Means

Time Series

TS Filler.png TS Filler
TS Plot.png TS Plot

Connectors

Download.png Download

Address

CASS.png CASS
Reverse Geocoding Macro.png Reverse Geocoding Macro

Developer

Blob Convert.png Blob Convert
Block Until Done.png Block Until Done
Dynamic Input.png Dynamic Input
Dynamic Rename.png Dynamic Rename
Dynamic Replace.png Dynamic Replace
Dynamic Select.png Dynamic Select
Field Info.png Field Info
Message.png Message
Run Command.png Run Command

Laboratory

Visual Layout.png Visual Layout

Consider yourself a Tool Master already? Let us know at community@alteryx.com if you'd like your creative tool uses to be featured in the Tool Mastery Series.


Stay tuned with our latest posts every #ToolTuesday by following @alteryx on Twitter! If you want to master all the Designer tools, consider subscribing for email notifications.

Comments
Alteryx Certified Partner
Alteryx Certified Partner

 Awesome work @MattD!

I love Alteryx and that means, I love the employees that make up the Alteryx team.  The idea to create an index of "weekly challenges" was a great addition and motivator for us to participate and lots of new folks are taking the challenge(s)!  After @TaraM unveiled her Periodic Table (with help from @AdamR) I thought of creating a Tool Mastery matrix and drafted a workflow to group the documents from the Knowledge Base and passed the workflow artifacts to friends there and WOW!   Great job in improving an idea for the betterment of the community.

 

Cheers!

 

Mark

Community Content Engineer
Community Content Engineer

Thank you, @MarqueeCrew!! Without your brilliant idea and proof of concept to piggyback off of, we wouldn't have known where to start! It's folks like you that make our work so easy - and even more rewarding.

 

Best,

Matt

Aurora
Aurora

Brilliant stuff @MattD - this was much needed, and you've done a great job of this!

Comet

This is fantastic, thank you.  I would love to see more of these series in the knowledge base and laid out in index form like this.  Well-documented help guides are invaluable for engaging my internal users, and give our learning groups a syllabus to work off of.  

 

While it is much smaller than the tool mastery series, it would be great if the CS Macro Dev series was similarly documented and also fleshed out a bit more.  There is so much power in developing Alteryx macros and it is an intimidating and thus under-utilized part of the software for my users.  For example, I was unaware for quite some time that I could use all of the interface tools to create more dynamic macros and thought their use was restricted to analytic apps.  Making users more aware of all of these options in a learning series would help expose all of the power under the hood of Alteryx.  

@MattD Great consolidation. Thank You for this awesome documentation 

Alteryx Partner

Just a quick reminder (I learned this the hard way recently) , that the Filter tool works differently to the Filter In-DB tool

 

Filter tool - all records that evaluate to 1 (ie TRUE) are T and all other records are F (ie FALSE)

Filter In-DB tool - all records that evaluate to 1 (ie TRUE) are T; all records that evaluate to 0 (ie FALSE) are F and all other records are ignored and are not output by the filter at all.