Alteryx Designer Desktop Knowledge Base

This article has an attached macro from Dr. Dan for grouping linear regressions by unique values in a column.

This article includes a macro for obtaining parsed statistics from the Linear Regression tool.

As a best practice, a data frame should always be defined before using write.Alteryx(). If this step is omitted, data may not be output correctly.

A quick reference guide that will help you prepare two different data sources for use with Fuzzy Match Merge Mode

This error occurs when a transaction limit is exceeded. It can be resolved by configuring bulk uploads on the server or using an iterative macro.

This error may occur with Desktop Automation schedules. It can be corrected by changing the Alteryx Service log on account.

This error occurs when the validation sample contains inconsistent data with the evaluation sample causing different data types for the same column.

Designer requires .NET version 4.7 or newer to use the TLS 1.1 or 1.2 protocols. For workstations with Windows 7, other configurations are also needed.

The SharePoint List Output tool cannot write to metadata columns. This capability will be added in a future release.

Error while installing additional R packages in Alteryx Designer - "GenericTool (1): Can't find plugin "AlteryxRPluginEngine.dll""

When trying to set up a System alias, but the System option is missing. How to troubleshoot this issue.

One common reason can be due to mixed cases within the data of the join fields between the two datasets. For example, and as shown below, "Orange" from the first dataset is not going to join to "orange" in the second dataset. And this does not just apply to the leading character. Another common reason can be due to the existence of trailing or leading spaces. As also shown in the example below, "Plum " is not going to join with "Plum". The little red triangle in the upper right-hand corner of "Plum" indicates that there are leading and/or trailing spaces.

This error may occur when using the AlteryxGraph device. The reason for this is that the AlteryxGraph device creates a pipe between Alteryx and R. If creating graphs in a loop, a pipe has to be created for each loop which slows down the processing. As a result, Alteryx ends up trying to create the next graph before the previous one is completed. To avoid this, it is best practice when creating multiple graphs within a loop to keep the AlteryxGraph device statement outside of the loop.

How do I create an index on a field in my database table? An index for a field can be created using the Post Create SQL Statement option (option #10) found in the Configuration window of the Input tool.

I have configured my map to zoom to a specific layer, but the map is not zooming as expected. I have confirmed that the 'Zoom to Layer' checkbox in the Layers tab of the Report Map tool is checked only for the layer in question.

Disk Management - File Size by Directory Report

FieldID does not match FileHeader

When attempting to publish a workflow to your private Gallery which contains the Publish to Tableau Server macro, you may encounter an error similar to this: “Cannot find macro "PublishToTableauServer_v1.08.1\Publish to Tableau Server.yxmc"

How To: Change Date Type Coming Out of Date Interface Tool to Match In-DB Field Date

Within Alteryx there isn't an output option directly to a text file. To achieve this you will need to use a flat ASCII file.

Sentiment analysis, key phrase extraction, and more.