Alteryx Designer

Definitive answers from Designer experts.
Some Salesforce users do not use Salesforce Security Tokens. An accepted IP range can be set up instead in Salesforce Admin. This article will walk you through the steps to modify the Salesforce Output tool to be able to be used without a Salesforce Security Token.
View full article
Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool
View full article
This article will walk through how to enable to Google Analytics APIs to be used in the Google Analytics Connector with OAuth2 login option
View full article
Latest versions of the Google Sheets and Google Analytics Connectors introduce ability to share a Connection Token across tools helping to stay under refresh token limit
View full article
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
When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears.
View full article
All the In-DB connections in Alteryx Designer are lost. Where are these settings stored?
View full article
Error: "Oracle driver: You are not licensed to use this DataDirect Technologies product" when connecting to Oracle in Designer.
View full article
Not able to clear the In-DB connection string history. There is no option or button to clear it.
View full article
Cannot update passwords in the Input Data or the Output Data tool.
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
When using the download tool with an SFTP or HTTPS connection, you may receive the error - Error transferring data: failed initialization. This often occurs when Designer can't agree on a cipher suite to communicate with the host server.
View full article
Spatial Data from SQL Server shows up as "None - View Browse Tool Map Tab" in the Input Data tool.
View full article
Error connecting to Office 365 using the Sharepoint Input tool - "The sign-in name or password does not match in the Microsoft Account system", when the user tries to connect to Sharepoint from the Alteryx Designer
View full article
How to retrieve the Client-ID and Secret code from the Google account to be used with the Alteryx Google Sheets connectors
View full article
In some cases a customer using the Publish to Tableau Server macro encounters the error message "Failed to start a new Hyper instance". The only currently working solution for this is to perform a nuclear uninstall and then reinstall of Alteryx Designer.
View full article
ERROR: "General error; 1033 error while parsing protocol" while connecting to SAP HANA DB using the Input Data Tool in Designer
View full article
Adobe Analytics Connector - Error: Adobe Analytics (2): Tool #43: Cannot find macro    Issue: The user can experience the following error message when using the Adobe Analytics connector tool.    Error: Adobe Analytics (2): Tool #43: Cannot find macro "AdobeAnalytics\Supporting_Macros\adobe-analytics-report.get.yxmc"   Environment   Product - Alteryx Designer (Admin and Non-Admin) Server   Cause   The is a known defect where the Adobe Analytics tool is not referencing the parent directory where the macro is stored. The following is an example of the changes    <EngineSettings Macro="..\Supporting_Macros\adobe-analytics-offline-authentication.yxmc" />     Solution   To resolve this Download the modified macros attached to this articles Unzip the folder  Navigate C:\users\<your username>\AppData\Roaming\Alteryx\Tools\AdobeAnalytics_v2.0.1\Supporting_Macros This folder contains four .yxmc files. Delete this files and replace them with unzipped fours downloaded macro Note: Do not just paste the into the existing folder without first deleting the contents as this will create 2 sets of macro rather them replace them.   Additional Resources   The 'How to Guide' to Adobe Analytics https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-How-to-Guide-to-Adobe-Analytics/ta-p/21304
View full article
Leading Zeroes Removed When Writing String Data to Google Sheets   When writing string data to Google Sheets that contain leading zeros, the leading zeros are removed after being written to Google:     Environment   Product - Alteryx Designer All Versions Product - Google Sheets Diagnosis   Google automatically formats values when they are written to a cell. The same behavior occurs when manually entering data into the sheet directly. When looking at the web traffic, one can see that the following is sent to Google from Alteryx:   <batch:operation type="update"/> <id>https://spreadsheets.google.com/feeds/cells/1YW6I6543216gsgsgsgsgD24j-hHA6ydcA/od6/private/full/R4C1</id> <gs:cell row="4" col="1" inputValue="00004"/>   The correct value "00004" appears as the InputValue. Google then returns the following:   gs:cell [ row=3 col=2 inputValue=4 numericValue=4.0 ]   Google has interpreted "00004" as a number and automatically converted it to "4."   Solution   You can workaround this by placing an apostrophe in front of the value within Alteryx prior to writing the data:     This forces Google to interpret the data as a string and include the leading zeroes. The following is a sample formula that adjusts all rows within a field to include a leading apostrophe:   "'" + [Field1]   Additional Resources   Google Sheets Output Help Documentation
View full article
This is the place to be if you are trying to learn how to download data from your Amazon S3 onto Alteryx Designer, or uploading data from Alteryx Designer to your Amazon S3 account. 
View full article
How to register and create Dynamics CRM Application on Azure
View full article