Alteryx Designer Knowledge Base

Troubleshooting error with Publish to Tableau Server tool: TypeError: Cannot read property ‘token’ of undefined

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.

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.

Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool

This article will walk through how to enable to Google Analytics APIs to be used in the Google Analytics Connector with OAuth2 login option

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

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.

When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears.

All the In-DB connections in Alteryx Designer are lost. Where are these settings stored?

Error: "Oracle driver: You are not licensed to use this DataDirect Technologies product" when connecting to Oracle in Designer.

Not able to clear the In-DB connection string history. There is no option or button to clear it.

Cannot update passwords in the Input Data or the Output Data tool.

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.

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.

Spatial Data from SQL Server shows up as "None - View Browse Tool Map Tab" in the Input Data tool.

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

How to retrieve the Client-ID and Secret code from the Google account to be used with the Alteryx Google Sheets connectors

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.

ERROR: "General error; 1033 error while parsing protocol" while connecting to SAP HANA DB using the Input Data Tool in Designer

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

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