Alteryx Designer Desktop Knowledge Base

Here we’ll delve into uses of the Download Tool on our way to mastering the Alteryx Designer.

Quick navigation for the Tool Mastery Series!

Guide on configuring and capturing a Fiddler trace for Troubleshooting issues.

The Filter Tool, which is part of the Preparation tool category, separates your data into 2 output streams, True and False, based on a basic filter or custom expression.

Far more than just a window to your data, the Browse Tool has a catalog of features to best view, investigate, and copy/save data at any checkpoint you place it.  That introspection to your data anywhere in your blending gives valuable feedback that often speeds workflow development and makes it easier to learn tools by readily visualizing their transforms. Be equipped, and browse through the catalog of useful applications below!

Here we’ll delve into uses of the Text Input Tool on our way to mastering the Alteryx Designer:

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Input Data Tool on our way to mastering the Alteryx Designer

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Join Tool on our way to mastering the Alteryx Designer:

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Union Tool on our way to mastering the Alteryx Designer

Unlike a snowflake, it is actually possible for duplicates exist when it comes to data. To distinguish whether or not a record in your data is unique or a duplicate we have an awesome tool called the Unique Tool that will actually turn your data into a unique snowflake.

Easily the most used tool in the parsing category, the Text To Columns Tool makes for an extremely quick dicing of delimited fields. To use it you only need to specify a delimited field, delimiter(s), whether you’re parsing to rows or columns (you’ll need to specify a number of columns to parse into with this selection) and you’re off.  Any way you slice it, this tool has you covered:

The Select Tool within the Alteryx Designer is the equivalent of your High School Sweetheart. Always there when you needed them and helped you find out more about yourself. The Select Tool can do exactly this by showing you the data type and structure of your data, but it also gives you the flexbility to change aspects of your dataset.

How to improve performance when reading from or writing to Snowflake.

Here at Alteryx we believe in working smart, not hard. Building out reports to highlight business-critical metrics is a pretty smart way to track goals. Customizing those reports to everyone in the department, then distributing them as attachments to individual emails? That sounds like a lot of hard work. Scheduling those reports from a refreshing data source each month so you don’t have to remake or rerun the reports yourself - that’s genius. Logging into your work computer to open up Alteryx, then having to check the scheduled results before having any peace of mind those reports were delivered without a hitch? Hard.

"Error: Designer x64: The Designer x64 reported: Error running Event #1: The external program "C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe" returned an error code: 2: The system could not find the environment option that was entered. (203)"

How to add a custom domain within the Salesforce Tools.

When using Auto Insights uploader v1.4 for Designer 2021.4, DCM needs to be enabled. And SDK Access Mode must be Allow instead of AllowAll

This article explains the steps in configuring the Personal Access Token in Tableau Online server, in order to use this in Alteryx Designer for a successful PAT(Personal Access Token) based connection

Data blending, transformation and cleansing..oh my! Whether you're looking to apply a mathematical formula to your numeric data, perform string operations on your text fields (like removing unwanted characters), or aggregate your spatial data (among many other things!), the Formula Tool is the place to start.  With the examples provided below, you should be on your way to harnessing the many functions of the Formula Tool:

The Append Fields tool adds every row of the source input to every row of the target input as new columns. This is also known as a Cartesian or cross join!

OneDrive is a file hosting and synchronization service operated by Microsoft. You can connect to a OneDrive instance in Alteryx with the OneDrive Input tool and the OneDrive Output tool.