Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Tool Mastery Index

MattD
Alteryx Community Team
Alteryx Community Team
Created

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.pngBrowse
Date Time Now.pngDate Time Now
Directory.pngDirectory
Input Data.pngInput Data
Output Data.pngOutput Data
Text Input.pngText Input
 

Preparation

Auto Field.pngAuto Field
Data Cleansing.pngData Cleansing
Filter.pngFilter
Formula.pngFormula
Generate Rows.pngGenerate Rows
Multi-Field Formula.pngMulti-Field Formula
Multi-Row Formula.pngMulti-Row Formula
Record ID.pngRecord ID
Sample.pngSample
Select.pngSelect
Sort.pngSort
Tile.pngTile
Unique.pngUnique
 

Join

Append Fields.pngAppend Fields
Find Replace.pngFind Replace
Fuzzy Match.pngFuzzy Match
Join.pngJoin
Join Multiple.pngJoin Multiple
Make Group.pngMake Group
Union.pngUnion
 

Parse

DateTime.pngDateTime
RegEx.pngRegEx
Text To Columns.pngText To Columns
 

Transform

Arrange.pngArrange
Cross Tab.pngCross Tab
Running Total.pngRunning Total
Summarize.pngSummarize
Transpose.pngTranspose
 

Reporting

Charting.pngCharting
Email.pngEmail
Image.pngImage
Insight.pngInsight
InteractiveChart.pngInteractive Chart
Layout.pngLayout
Render.pngRender
Report Footer.pngReport Footer
Report Header.pngReport Header
Report Map.pngReport Map
Report Text.pngReport Text
Table.pngTable
 

Documentation

Comment.pngComment
Explorer Box.pngExplorer Box
Tool Container.pngTool Container
 

Spatial

Create Points.pngCreate Points
Distance.pngDistance
Find Nearest.pngFind Nearest
Spatial Info.pngSpatial Info
Trade Area.pngTrade Area
 

Interface

Action.pngAction
Apps and Macros.pngApps and Macros
Check Box.pngCheck Box
Control Parameter.pngControl Parameter
Date.pngDate
Drop Down.pngDrop Down
Error Message.pngError Message
Macro Input.pngMacro Input
Numeric UpDown.pngNumeric Up Down
Radio Button.pngRadio Button



Data Investigation

Association Analysis.pngAssociation Analysis
Basic Data Profile.pngBasic Data Profile
Contingency Table.pngContingency Table
Field Summary.pngField Summary
Histogram.pngHistogram
Pearson Correlation.pngPearson Correlation

Predictive
Boosted Model.pngBoosted Model
Decision Tree.pngDecision Tree
Forest Model.pngForest Model
Linear Regression.pngLinear Regression
Logistic Regression.pngLogistic Regression
Neural Network.pngNeural Network
Score.pngScore
Test of Means.pngTest of Means

Time Series
TS Filler.pngTS Filler
TS Plot.pngTS Plot

Predictive Grouping
Append Cluster.pngAppend Cluster
K-Centroids Cluster Analysis.pngK-Centroids Cluster Analysis
K-Centroids Diagnostics.pngK-Centroids Diagnostics

Prescriptive
Optimization.pngOptimization

Connectors
S3 Upload and Download.pngAmazon S3 Upload and Download
Download.pngDownload
One Drive_input.pngOne Drive

Developer
Blob Convert.pngBlob Convert
Block Until Done.pngBlock Until Done
Dynamic Input.pngDynamic Input
Dynamic Rename.pngDynamic Rename
Dynamic Replace.pngDynamic Replace
Dynamic Select.pngDynamic Select
Field Info.pngField Info
Message.pngMessage
Python.pngPython
Run Command.pngRun Command

Laboratory
Visual Layout.pngVisual 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.



null
No ratings
Comments
MarqueeCrew
19 - Altair
19 - Altair

 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

MattD
Alteryx Community Team
Alteryx Community Team

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

SeanAdams
17 - Castor
17 - Castor

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

mcarrico
9 - 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.  

smithajose
5 - Atom

@MattD Great consolidation. Thank You for this awesome documentation 

cmcclellan
13 - Pulsar

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.

sherat
6 - Meteoroid

Very useful place to get functionality knowledge

thomas_vdb
7 - Meteor

Excellent resource, thanks @MattD.

 

To know how to better direct users to each link, based on which tools their workflows are using, I'm trying to build this: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/List-all-tools-used-in-a-workflow/m-p/...

 

Will update you about/if it works Smiley Very Happy

 

TonyaS
Alteryx
Alteryx

This is fantastic! 

nkrishnakris
7 - Meteor

The list needs to be updated, it will help if you update with the list of tools that have added newly like Map Legend Splitter Tool & Map Legend Builder Tool

PraphulSamavedam
8 - Asteroid

I like this idea of maintaining the index for the content. Mark the indices and then make your way to the particular tool you want to go at. Inspired from this idea, our team is also employing similar idea in our project. (just wanted to share that). 

 

rartt
Alteryx
Alteryx

Hi, the Cross Tab Tool Mastery page appears to be broken. Please could someone take a look?

Samanthaj_hughes
12 - Quasar
12 - Quasar

Ah MattD, I have rediscovered this after losing my bookmark and not digging it out in a while and I still love this page. Thank you for keeping it here! S*

Emil_Kos
16 - Nebula

Hi @MattD,


I loved this index. So big part of Alteryx knowledge in one place. I love it! 

vijay_vittal_1
7 - Meteor

I Should have given this a look, before my CORE Exam. Missed by a percent.