community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
 You are using an unsupported browser for translation. Please switch to another browser.

This short, but packed demonstration will show you why tens of thousands of data analysts from more than 1,800 companies rely on Alteryx daily to prep, blend, and analyze data, to deliver deeper business insights in hours, not weeks.
View full article
Instruction on how to obtain the list of deprecated tools in Alteryx Designer!
View full article
Querying a Salesforce report using the Salesforce Input tool returns a maximum of 2000 records.
View full article
Steps to troubleshooting an "Unhandled Exception" error when attempting to open the Manage Data Connections window.
View full article
Question Does "Dictionary Sort Order" always place lower case letters before capital letters?  Answer Yes.  In the Sort-Configuration menu there is an option to "Use Dictionary Order".  When checked it will sort in alphabetical order with lower case first (e.g., a, A, b, B, c, C, etc.).   Input:   If you do not have "Use Dictionary Order" checked, it will sort all Upper case first and then all lower case (e.g., A, B, C, a, b, c, etc.).   Check "Use Dictionary Sort Order.     Dictionary Sort Order   Visit the sort help article or the attached workflow for more details.
View full article
For Python-based tool developers, a guide to including wheel files within your tool installer.
View full article
What happens when one installs the YXI file of a Python-based tool in Alteryx Designer.
View full article
Troubleshooting instructions for the error The system cannot find the file specified when attempting to use a 32-bit database connection in the Input Data or Dynamic Input Tool.  
View full article
Upgrade from Alteryx 11.7 or prior to the Latest Version in 10 Easy Steps!
View full article
What to do when you see the "CASS engine appears to not be installed" error.
View full article
When bringing data into Alteryx a lot of users often add a  select tool  to check the data type and structure. Data types are very important because of the available operations/functions in tools can be adjusted to fit the data type being used!
View full article
Time series forecasting is using a model to predict future values based on previously observed values. In a time series forecast, the prediction is based on history and we are assuming the future will resemble the past. We project current trends using existing data.
View full article
An index for all the Alteryx Product technical specifications and system requirements!
View full article
Tired of connecting tools one-by-one? This can definitely become inconvenient when you want to join/union many inputs or if you want to run a slew of analyses...
View full article
Sometimes you look at the steaming pile of data before you and wonder how you’ll ever get it in the form you need. Every option seems to require a great deal of manual labor, and as a lazy– er that is , as a data blending professional , that is simply something you will not abide.
View full article
Have you ever used the ConsumerView Analytical File in US Core Data and stared wide-eyed at the codes returned? There is now an alternative to looking in the documentation for the coded values! The  ConsumerView Renaming Macro  allows you to rename the codes into readable data.
View full article
  Question   When importing a .xls file using the Input tool, Alteryx produces NULL values for specific cells, why does this happen?   Summary   By design, Alteryx uses either the Jet or ACE drivers when importing .xls files. In short, it’s not really an Alteryx issue but rather a limitation on the Microsoft drivers, but there’s always a workaround available, and we’ll dig into it later.   One of the common reasons this happens is due to the logic both the JET and ACE drivers follow. By design, they look at the first eight rows in your document when identifying the data types and their lengths, when it comes to handling Legacy Excel files. Translation, please? If at least one cell within the first eight rows of your file contains more than 255 characters, then the drivers will set the data type as “memo” (i.e., a length that can hold up to 32,768 characters). Now if the data type doesn’t exceed 255 characters within the first eight rows the driver sets the data type as a string with a 255-character restriction. How does this relate back to you? Well, if any of your cell values that are after the first eight rows do surpass 255 characters, then the driver will assign a NULL value to those cells. Confusing, right? It’s a good thing all is not lost, at least not yet.   Solution   The user has the choice to work around this issue or fix it in their registry. The workaround includes the following: From the Input Data Tool configuration, check option 6: "First row contains data." This will force all fields as a V_String. Configure the Dynamic Rename Tool to "Take Field Names from First Row of Data." Use the Auto Field Tool to assign the best field type for each data column correctly. The fix for this involves changing a setting in your registry. These instructions are being provided as well as documented from Microsoft, as Alteryx cannot be sure that changing this setting will not cause problems with other applications. For more information on this issue: http://support.microsoft.com/kb/189897.   To change the Registry setting*** Go to Start > Run and type "regedit" In the registry go to HKey Local Machine > Software > Microsoft > Jet > 4.0 > Engines > Excel Double Click: TypeGuessRows Change the value to 0 (zero)   Another workaround is to save the .xls file as a .xlsx. It’s well known that Microsoft hasn’t updated the legacy file extension since 1997. If this is an option you desire to exercise, fear not, there is a Macro for that, especially if you need to convert files by the masses.   Quick Shout out to DanJones for creating a fantastic app that takes a directory path and converts all xls files to csv or .xlsx respectively. https://community.alteryx.com/t5/Data-Sources/Error-opening-an-XLS-not-xlsx-file/td-p/47085/page/2 The post is located all the way in the bottom.   Disclaimer, when it comes to converting a .xls as .xlsx, please review if your workflow has a lot of formatting enabled, if so, please remember that sometimes this will potentially create inconsistencies with your data. It’s also possible to lose some data in the process.   Appendix   *** For performance reasons, setting the TypeGuessRows value to zero (0) is not recommended if your Excel table is enormous. When the value is set to zero, Microsoft Excel will scan all records in your table to determine the type of data in each column. Source: https://help.alteryx.com/2018.1/index.htm#FAQ.htm?Highlight=xls   Thanks for reading! If you have any questions, please message away!
View full article
This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.
View full article
You may have run across this error, using the html plugin predictive tools (Linear Regression, Logistic Regression, Decision Tree):   Logistic Regression: Error in searchDir(dbDir, lang) : Logistic Regression: Expecting a single string value: [type=NULL; extent=0]     In 2018.2, this can happen when you have previously had an Admin version of Designer installed, but have since uninstalled.  Once you've installed the 2018.2 non-Admin version with Predictive tools, these errors will now occur.   Help is on the way!  (In the form of suggestions and an upcoming stable release.)  You have several options.  First, you can install an Admin version of Designer concurrently - 11.8, 2018.1, 2018.2, etc.   Last ditch effort: delete registry keys.  This is not recommended - only delete keys if you cannot install a current version, or cannot wait until the next stable update.   Step 0) Save your license key somewhere easy to find: Options> Manage Licenses   Step 1) Open the Registry Editor (type regedit into your windows search bar) and delete the following directory: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx   Now, go predict stuff!  Happy Alteryx-ing.
View full article
You know what really stinks? Working with addresses that aren’t standardized or verified. Whether human-input, or one of the many address formatting standards in the U.S., being stuck with an address you can’t either (1) identify or (2) ensure it exists can be a real pain in the… well…   CASS is here to help!
View full article