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.

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
You’re creating an app that involves dates. You want the user to be able to dynamically select the dates being used in the app, though. The tools you already know may not work. A  Text Box  would be too messy and allow lots of room for error. Pre-defined  Drop Downs  and  List Boxes  aren’t dynamic enough. Ah ha! What about that tool that looks like a calendar? The  Date  tool in the  Interface  category provides the perfect solution!
View full article
A part of the Spatial Tools Category, the Distance Tool calculates how far apart spatial objects are.
View full article
The  Date Filter  tool is a very tailored version of the  Filter  tool with an enhanced  GUI  for date picking.
View full article
A close relative of the  Layout Tool , the  Visual Layout Tool  is the newest, and coolest,  Reporting Tool  on the block. Sporting all the badassery of the original Layout Tool in its ability to format and arrange reporting objects, the Visual Layout Tool differentiates in that it provides an intuitive, visual, interface that allows for easy drag-and-drop organization of multiple reporting object inputs. Basically, it’s the reporting tool category equivalent of upgrading from Paint to Photoshop.
View full article
Don’t know the area of your polygon? Need the length of your line? Do you want your spatial object’s X and Y coordinates? Don’t Panic! The Spatial Info tool can translate all that information and more!
View full article
The  Radio Button Tool  can be used in a number of ways. This is a simple tool to configure but can be very powerful!
View full article
The  Join Multiple  tool is a combination of the  Join  and  Union  tool. It is best used to consolidate a workflow into one tool when you would instead use Multiple Join then Union tools.
View full article
If you are building a predictive model, inevitably you will want to analyze the effect that your independent variables have on your dependent variable. This article is meant to shed some light on the Alteryx-specific options for this type of analysis!
View full article
The  Dynamic Replace Tool   is an under-utilized tool in the   Developer Toolset  that is very powerful. It allows for dynamic formulas or conditions to be used in your workflow.  It was first introduced in Alteryx 6.1 . It’s one of the few tools that is currently multi-threaded which makes is fast.
View full article
The humble  histogram  is something many people are first exposed to in grade school. Histograms are a type of bar graph that display the distribution of  continuous  numerical data. Histograms are sometimes confused with bar charts, which are plots of categorical variables.
View full article
Very large numbers don't behave the way users expect. Often, it's better practice to handle a big number like that as a String.
View full article
Set yourself up for success with excerpts from the 2017 Tips and Tricks Book for bringing data into your workflows!
View full article
The  Numeric Up Down Tool  can be used in a variety of ways to enhance your macros and apps. This very simple tool requires just a few seconds to configure and you're on your way!
View full article
Set yourself up for success with  excerpts from the 2017 Tips and Tricks Book for workflow design!
View full article
The  Transpose  tool pivots data for all selected fields. The column headers are listed in the name field and the corresponding data items are listed in the value field. You can also select key fields which will remain unchanged through the transformation. The transpose tool is often used in conjunction with the  Cross Tab  tool, which essentially works in the opposite direction.
View full article
A must-have for any app or macro, the  Error Message Tool  displays a prompt to the user based on input from  Interface Tools . Using any expression that evaluates to true, along with any number of user inputs from question  anchor connected Interface Tools, the Error Message Tool can layer even the most involved applications with failsafes that ease a user’s experience through more robust interactions.
View full article
The Arrange Tool allows you to manually transpose and rearrange your data. It can be used to combine multiple fields into a single target field.
View full article
Thanks to the brilliance of  @RobertB  during last year’s Alteryx Innovation Days, we now have  a command line tool in beta  that generates visual markup in the Designer to compare two workflows!
View full article