Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
This article has been archived. Please reach out to community@alteryx.com if you have any questions.
View full article
Every new release of the Designer hosts the latest documentation at  http://downloads.alteryx.com/documentation.html!
View full article
The Contingency Table tool is a part of the Data Investigation category in Alteryx Designer, which comes as a part of the predictive tools installation. Intuitively, you can use the Contingency Table tool to create a contingency table. 
View full article
  ISSUE:   Error “ Error: Publish to Tableau Server (1): Tool #252: Tool #4: Tableau Server API Request (Publish file) Error Code 400011: Bad Request -- There was a problem publishing the file ‘ ’ “ when publish .hyper file of Excel with data source metainfo (.tds) file.   Repro Step:   Connect to an Excel file on Tableau Desktop Create an Extract with .hyper extension Then right click on the data source > add to Saved Data source, to create the metadata file (.tds) file Open Alteryx Designer, connect to the same Excel file using input tool Drag a publish to Tableau Server tool, type in all the relevant information, for Data source metainfo (optional), select the .tds file created in step 3 When run the workflow, this error would occur   Resolution:   Option 1 Do not create extract of the file, for text based file, do no need to create a local copy After created the .tds file (add to Saved Data source) , open the .tds file in a text editor like notepad ++ Modify on line 8, where filename = ‘ ’, change the path to UNC path + The original one looks something like: filename='H:/output.xlsx' + Change it to something similar to the following: filename='\\extendthereach.com\alteryx\CustomerSupport\output.xlsx'   Note: As a best practice, have the original Excel file in a share drive if it need to be used for other users in the organization or it will need to refresh on Tableau Server in the future. And make sure Tableau Server Run As User account has the sufficient permissions to access the share drive.   Option 2 -   If the Excel file has to be located on the end user’s machine, change the path in TDS file (line 😎 to something like the following when the file in on local machine:    filename='\\?\C:\Users\kchen\Documents\Example named ranges.xlsx'   Note: If the Tableau Server Run As account does not have sufficient permission to access the share drive where the file is located, the following error would occur when connected to the Data source on Tableau Server:     “Unable to connect to the file "C:/Users/<Username>/Document/filename.xlsx". Check that the file exists and that you have sufficient access privileges for it. DataServiceFailure Unable to connect to the server "localhost". Check that the server is running and that you have access privileges to the requested database.”     See following Tableau KB for more information: https://kb.tableau.com/articles/issue/error-unable-to-connect-to-the-file-file-path-Check-that-the-file-exists-and-that-you-have-sufficient-access-privileges-for-it-refreshing-extract  
View full article
Symptoms   “Unhandled Exception occurred” error is thrown when you copy and paste text (Ctrl-V) using the R Tool.     Now, to witness it happening:     Diagnosis   Looking at the error log you will see error message below:   Default Log path - C:\ProgramData\Alteryx\ErrorLogs\AlteryxGUI         If you look at the log, you can see the error is directly related to the FIPS cryptographic algorithms. According to Wikipedia, FIPS stands for Federal Information Processing Standards and it is a “standard developed by the United States federal government for use in computer systems by non-military government agencies and government contractors”.   As of right now, “Unhandled Exception occurred” error will be thrown in the R Tool if FIPS compliance is turned on .    Solution   Our Development team is fully aware of the problem with the FIPS compliance and is planning to sort this out in the future releases. As for temporary solution, you can consider turning off the FIPS compliance, of course after checking and making sure your IT manager is okay with it, and this should resolve the “Unhandled Exception occurred” error.   Here’s how you can turn off FIPS compliance:   There are other ways to turn on/off FIPS compliance and you can find them here:   https://www.howtogeek.com/245859/why-you-shouldnt-enable-fips-compliant-encryption-on-windows/   Eddie Wong Alteryx CSE
View full article
As most of us can agree, predictive models can be extremely useful. Predictive models can help companies allocate their limited marketing budget on the most profitable group of   customers,  help non-profit organizations to find the most willing donors to donate to their cause, or even determine the probability a student will be admitted into a given school. A well-designed predictive model can help us make smart and cost-effective business decisions.
View full article
  Our incredible user community came through once more with their most valuable Alteryx tips & tricks, these along with our own are now captured in our Tips & Tricks 2018 book.   Our sincere gratitude to our user community for their contributions and for attending our session at Inspire 2018 !   Enclosed is our 100 + pages of tips & tricks … enjoy !     Margarita, Henriette & Jessica Customer Support Engineering
View full article
Logistic Regression is different from other types of regression because it creates predictions within a range of 0-1 and it does not assume that the predictor variables have a constant marginal effect on the target variable - making it applicable to many dichotomous problems including: estimating the probability that a student will graduate, the probability that a voter will vote for a specific candidate, or the probability that someone will respond to a marketing campaign.
View full article
“Ponder and deliberate before you make a move.”  - Sun Tzu, The Art of War
View full article
The cause and solution to the "DisableAllOutputForLicense" error with the Predictive Tools.
View full article
One trick I often use to conditionally update a field is the Boolean  IIF  function.  IIF is basically a shorthand version of a single condition test.
View full article
A guide to RgEx syntax in Alteryx!
View full article
The addition of page numbers to a report is quite simple, there are two steps: First, add a Text tool immediately before your Render tool.  In the Text tool, under the Special Tags drop-down select the Current Page option.  The example below is a more elaborate example employing the annotation text “page” and “of” and the special tags to display the current page and total number of pages in the document. Secondly, in your Render tool, check the Footer checkbox, and select the “Text” field as the field to display for the Footer.   Done!
View full article
When creating a finance report with the Alteryx reporting tools, you might want to annotate numbers a certain way. This article will show you how!
View full article
How to make optional fields in an analytic app.
View full article