Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
Error while connecting to a database, from the Input Data Tool - Error: Input Data (13): Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
View full article
Troubleshooting the error: At least one (Data) Field must be selected
View full article
Troubleshooting Parse Error at char(n): Invalid type in operator [== < > + -]
View full article
Troubleshooting the error: Both left and right inputs must have connections
View full article
User is getting a "missing dll" or "file not found" error when writing spatial data using the bulk loader
View full article
Troubleshooting the At least one CrossTab Method must be specified (Not counting Total Row) error.
View full article
Here is a list of items that we suggest get whitelisted for antivirus software to reduce unexpected behavior.
View full article
Error when publishing or running on Gallery a workflow that contains a Google Sheets tool.
View full article
Troubleshooting the error: The formula "[formula_name]" resulted in a string but the field is numeric. Use ToNumber(...) if this is correct.
View full article
Troubleshooting the error: No fields selected to sort
View full article
An error is thrown when attempting to overwrite cells in Excel that are already prepopulated with values that are generated with a formula.
View full article
when the background color of the Report Text Tool is set to [None], when being rendered to Excel the color returning as black
View full article
Troubleshooting the error: There were more than 16 records in the source.
View full article
"Error: Input Data (1): Error opening connect string: Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.\08001 = 18" after upgrading SQL Server to 2019 and disabling TLS 1.0 and 1.1
View full article
Scheduled Workflow is stuck in "Initializing" status
View full article
Troubleshooting Parse Error at char(0): Empty expression (Expression #n)
View full article
how to convert a base64 to text utf - 8
View full article
SQL Server read performance is slow in Designer.
View full article
Depending monitor display settings, an Alteryx application may not appear the same way as it does the Interface Designer Layout View. There may be instances where components appear in the wrong area of the screen, or they are missing altogether.
View full article
This article provides a resolution for an error occurring with the 2021.2 Principal Components Sample Workflow.
View full article
Error when using the Assisted Modeling tool on a Proxy environment
View full article