Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
If you observe an error message like Error: Salesforce Input (1) File " ", line 1 os.environ['PATH'] = r"... please read on to learn how to adjust the environment variables to resolve it. This can happen with any one of several Connector tools, not just the tool mentioned in the example.
View full article
Publish hyper file to Tableau Server 2020.2 or Online does not contain Number OF Record field. This might cause the the views/dashboards be broken.
View full article
Querying a date from the Alteryx Server Persistence MongoDB using the MongoDB Input tool can be tricky since Alteryx Server dates are stored as string values. Here is how to use regex in the criteria section of the MongoDB Input tool.
View full article
Troubleshooting the error InboundNamedPipe when writing out a .hyper file from an Output tool or the Publish to Tableau Server tool
View full article
This KB explains how to query views with the Google BigQuery Input Tool
View full article
a guide to effectively use Salesforce Tools
View full article
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.
View full article
This error may occur with Desktop Automation schedules. It can be corrected by changing the Alteryx Service log on account.
View full article
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.
View full article
The SharePoint List Output tool cannot write to metadata columns. This capability will be added in a future release.
View full article
Sentiment analysis, key phrase extraction, and more.
View full article
Spatial Data from SQL Server shows up as "None", "Null", or other characters in the Input Data tool.
View full article
Not able to clear the connection string history. There is no option or button to clear it.
View full article
Use the Google BigQuery Input tool to query a table from Google BigQuery and read it into Designer...
View full article
How to register and create Dynamics CRM Application on Azure
View full article
How to troubleshoot when the Salesforce Output tool does not appear in the tool palette.\n  
View full article
Web Crawling in Designer
View full article
Error: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator
View full article
Ever wish you had an easy way to read in data to Alteryx Designer from your Quickbooks Online account? Well, now there's a tool for that. This article will describe how to make an API call to QuickBooks Online through the QuickBooks Input Tool attached to this article. 
View full article
When sharepoint lists have date fields, they are off by the UTC current timezone set in sharepoint.
View full article
Error when publishing or running on Gallery a workflow that contains a Google Sheets tool.
View full article