Tool Mastery Index

[MattD]

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
	Date Time Now
	Directory
	Input Data
	Output Data
	Text Input

 

Preparation

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

 

Join

	Append Fields
	Find Replace
	Fuzzy Match
	Join
	Join Multiple
	Make Group
	Union

 

Parse

	DateTime
	RegEx
	Text To Columns

 

Transform

	Arrange
	Cross Tab
	Running Total
	Summarize
	Transpose

 

Reporting

	Charting
	Email
	Image
	Insight
	Interactive Chart
	Layout
	Render
	Report Footer
	Report Header
	Report Map
	Report Text
	Table

 

Documentation

	Comment
	Explorer Box
	Tool Container

 

Spatial

	Create Points
	Distance
	Find Nearest
	Spatial Info
	Trade Area

 

Interface

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

Data Investigation

	Association Analysis
	Basic Data Profile
	Contingency Table
	Field Summary
	Histogram
	Pearson Correlation

Predictive

	Boosted Model
	Decision Tree
	Forest Model
	Linear Regression
	Logistic Regression
	Neural Network
	Score
	Test of Means

Time Series

	TS Filler
	TS Plot

Predictive Grouping

	Append Cluster
	K-Centroids Cluster Analysis
	K-Centroids Diagnostics

Prescriptive

Optimization

Connectors

	Amazon S3 Upload and Download
	Download
	One Drive

Developer

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

Laboratory

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.

[MarqueeCrew]

 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_AYX) 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]

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]

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

[mcarrico]

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]

@MattD Great consolidation. Thank You for this awesome documentation 

[cmcclellan]

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]

Very useful place to get functionality knowledge

[thomas_vdb]

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

[TonyaS]

This is fantastic! 

[nkrishnakris]

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]

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]

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

[Samanthaj_hughes]

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]

Hi @MattD,

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

[vijay_vittal_1]

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

[Manish_Joshi]

This is fantastic, thank you. 

[J_Solano0701]

Sooooo Needed This Tool "Kit" - Thank you so much for posting!!

[sameerkrp]

This is really a great help for the beginners, great work. Thank you

[Skarthikak]

Great Consolidation

[Vrushali13]

Very useful

[sunilgunjkar]

Great work it is very helpful for beginners to know about all palette.

[Anugroho]

@MattD  ... you're superb , fortune I found this Tools Mastery Index. For me, this is a trusted tool of adventurers around the Alteryx world getting quick in the time and ideas will it used. Thank you to organize those tools. Great job and very inspiring.