This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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
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.
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:
Product - Alteryx Designer
Product - Google Sheets
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:
<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."
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]
Google Sheets Output Help Documentation