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 are un lucky while rendering a map in Alteryx with a Carto base map, you may encounter the error message Error: AGG error loading font (C:\WINDOWS\fonts\C:\Program). This article explains the cause of this error, and how to resolve it.
“Unhandled Exception occurred” error is thrown when you copy and paste text (Ctrl-V) using the R Tool.
Now, to witness it happening:
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 .
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:
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.
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.
Question How can I share my workflows if my recipients don’t have the same files they reference? Sending them all over separately and reconfiguring inputs separately seems like a lot of work. Halp!
Answer You’re right, that does sound like a lot of work. Luckily, we have an export feature to help with this exact scenario:
Navigating in your Designer to Options >> Export Workflow will open a menu where you can include assets that are referenced in your workflow and export them into a single .yxzp file to be shared. Feel free to select whichever files you’d like to include – if a file is missing, try attaching an additional asset/file to the tool it’s associated with. At that point it should appear in your export options:
Note: If your workflow uses a database connection, your recipient will need to either 1) have a DSN set up (system preferred) for the connection string used or 2) use the same alias to establish a connection in their environment.
After you select the files to be included, select “Browse” to specify the location and name of the export:
You should be all set! Share this export with your files included.
To open an exported workflow, simply File >> Open Workflow >> Browse in Alteryx or double click the green .yxzp file like any other Alteryx file type:
You should then see a prompt stating that the file is an Alteryx Package; just hit “Yes” to begin the import:
You’ll then be given the option to change the directory that the export is extracted to; below that option you will see the exported files listed with their locations relative to the destination directory:
Select “Import” to proceed:
Once the export has successfully extracted, you will be given a notification that the import process has completed. Select “Yes” and your exported workflow should already be loaded and ready to run!
Here at Alteryx we believe in working smart, not hard. Building out reports to highlight business-critical metrics is a pretty smart way to track goals. Customizing those reports to everyone in the department, then distributing them as attachments to individual emails? That sounds like a lot of hard work. Scheduling those reports from a refreshing data source each month so you don’t have to remake or rerun the reports yourself - that’s genius. Logging into your work computer to open up Alteryx, then having to check the scheduled results before having any peace of mind those reports were delivered without a hitch? Hard.
Question Have you ever wanted your own help page for your custom macros or applications?
Answer If you create your own macros or applications and send them to other who aren’t as familiar with your project, or if you just need a refresher from time to time, you may try and access the help menu only to be greeted by the general Alteryx macros/apps pages:
Macro Workflows Page
Analytics App Workflows Page
You can actually create your own help pages/files that can be accessed how you would normally access the Alteryx Help Menu for any "out of the box" tool that comes with the Designer.
Using your favorite text editor (Microsoft Word, for example), you can create your help file with any instructions or graphics that you feel would be helpful to the end users who may need to access a help file. Once you are done, you can save this in any file format that your (or your users') machine is able to open, as well as any location those users would be able to access (a network drive for example).
In your application or macro’s Interface Designer Properties, there is an option to add the path of a file or hyperlink to your newly created help file.
For an example I created the following help file as a .docx, .pdf, and .htm file type. Each other these files open in their respective default programs.
Question Did you know that instead of having to choose a save location in the Output Tool, you could leverage the directory that is used to save your temporary files?
Answer This can be handy if you are running chained apps locally or have macros that have a file output process. To use temporary space instead of actually writing out a file to a specified location. All you have to do is add the following onto your file name: %temp%..\Output.yxdb. Once you run your workflow you can navigate to your temporary directory (which can be found in System Settings->Engine->General->Temporary Directory) to view your saved file.
The same path you used in the output tool can be used in an input tool to read in the file that is saved to the temporary directory.
If you’ve gotten accustomed to having headers and sub-headers (fields/sub-fields) in your tables, much like those you can build with the “Merge & Center” Excel feature, you’ll be happy to hear with just a couple formatting steps we can build the format below:
In Alteryx, with similar formatting:
The attached v10.5 workflow goes into the details of the approach, but the essence is below:
Split your columns/fields your desired categories (making them sub-headers)
Create tables from your categories, add your supra-headers
Combine the reporting elements we have now, use the Union Tool to stack and the Summarize Tool to combine the reporting elements horizontally
Combine your sub-tables into a larger table, if needed (adding another header)
There you have it! Your tables are now rendered in style.
The Geography Analysis Collection (GAC) is a collection of user-friendly applications, or apps, that perform spatial analyses while leveraging demographic and firmographic data for business insights. The GAC allows subscribers to this particular gallery collection to quickly and easily produce maps and reports for selected geographies using five different apps. One such app is the Market Analysis app, which considers both current conditions and future projections when assessing the desirability of a particular market. This app leverages Experian, US Census and D&B datasets to highlight demographic and firmographic trends in both map and report format for a particular geography.
Users are given a great deal of flexibility in deciding how to designate the spatial area of interest for mapping and reporting. With both pre and user-defined options for geographic inputs, app users have many options for determining the spatial inputs to the app. Each option, however, has certain configuration aspects that may make the difference between an error message and a successful app run.
Unlike most of the other apps in the GAC, the Market Analysis app requires a polygon as its spatial input as opposed to point features. The Market Analysis app’s geographic input may be pre-defined using one of the app’s embedded options or user-defined. Pre-defined inputs use Experian’s geographic units as the spatial input (Figure 1A). Users can select up to 500 geographies that include areas such as Census Tracts, Counties, Congressional Districts and Zip Codes, among others. Pre-defined geographies may also be combined into a single unit, thereby summarizing the results for multiple geographic units into a single unit. Users may also define a particular geography to run through the app by creating a polygon on the interactive map (Figure 1B) or by loading in a file that contains polygons for the area of interest (Figure 1C). For both of these instances, the polygon must have a name that is either entered via interface prompts (using the interactive map) or as a field (uploading a file). User-defined files can include Esri shape files (.shp), GoogleEarth files (.kml), Database files (.dbf) and Excel files (.xlsx)*.
*Multi-part files, such as ESRI shapefiles, must include all spatial components in a zipped file (e.g., .DBF, .PRJ, .SHP, .SHX).
Figure 1: Spatial inputs to the Market Analysis app can be pre-defined (A) or user-defined (B and C).
A subscription is required to access the Geography Analysis Collection. Contact firstname.lastname@example.org to learn more!
Interested in getting an email notification whenever a workflow is executed and fails? This is particulary handy if you have created a workflow, published it to a gallery (Alteryx cloud solution) and you've enabled other users with the ability to run your workflow from the gallery so you have the option of following up to offer assitance. What follows are step-by-step instructions for setting up an email event in your workflow.
Click anywhere on the canvas, away from your workflow so you see the Workflow Configuration window.
Click on the ‘Events’ tab. Make sure ‘Enable Events’ is checked.
Click on the ‘Add’ dropdown and select ‘Send Email’.
A new widow, ‘Edit Event’, will open. On the ‘Run Event When:’ drop down, select ‘After Run With Errors’. Notice other options are available as well - 'Before Run' and 'After Run', for example. Add your email address to the ‘From:” and “To:” Lines. The email will be automatically pull in information regarding your workflow errors in the Subject and Body of the email.
Even if you save this workflow to the Gallery (public or private), the settings will be retained. In other words, if this workflow is executed from the Gallery - even if another user executes it - whoever your specificed as the email recepient will continue to get an email. Notice you are not just limited to getting emails if a workflow has errors. You can set it up so you get an email before run, after run, or when a workflow run without errors. You can also include an attachment to the email so if your workflow produces an output, you can attached that output file to the email.
Question Is the Alteryx Help available in languages other than English?
Answer Yes! Currently the Alteryx Help file is translated in French, German, and Portuguese (Brazil). For the latest, click here:
You will also find the Alteryx Server Quick Start Guide in the same languages.
Find yourself with latitude and longitude coordinate pairs for your spatial objects but not much else information on the locations? In Alteryx 10.0, if you need more geographical information on a coordinate, try converting it into a spatial object and using the Find Nearest Tool to find coinciding Experian geographical data from an Allocate Input Tool. This can be used to reverse geocode less granular address information such as ZIP Codes, counties, states, and even approximate “places.” Just be sure to send it in with a record ID, as the Find Nearest Tool will append a row each time it finds the closest specified value for each selection:
You can control-click any number of tools to highlight them, then move them around as a group.
You can click, hold and drag (to draw a box), and all tools covered by the box will be highlighted as you go; release, and then pick up and move that assembly of tools around as a group.
Employing the tactics in a and b above, you can also copy and paste tools within your module. You can cut too. To go a step farther, you can copy tools in one module and paste them into another, which is a great way of breaking a process out for a little more focus, or to minimize the amount of processing your machine does every time you click Run.
Another great tip is to Copy and Paste your Text Comment tools. Perhaps you’ve taken our advice about annotating your modules… You can create a module that’s designed only as a container for your most frequently used Text Comment settings. This will save you the effort to change background colors, font sizes, etc. every time you add a Text Comment.
Depending on the tool, formulas and other configuration selections will carry over when copy/pasted. This is especially useful when configuring formulas that have been used in previous modules.
Sometimes multiple conclusions can be drawn from the same data. Ok, often multiple conclusions can be drawn from the same data. This is especially the case with the Connection Progress that pops up between tools. You may be a bit familiar with this already. When you run a module, you may see something similar to the following: 114gb of data is being passed through my data stream! Is this a lot? Well, yes, but ultimately we have to remember that Alteryx processes everything in memory. Knowing this, the information that we see above doesn't mean we have 114gb of data being written directly to disk (many PC's don't even have this much available). Simply put, there is a ton of data there but if you do not have any type of output connected to the tool, it stays in memory. If we were to connect say, a Browse Tool to the end of my XML Parse Tool shown above, the temp file written out by my Browse Tool would in fact be every bit of that 114gb. Luckily, I don't really need the data written out at this point (I'm performing further analysis downstream), so I simply add a Select Tool just after this and de-select the field with the massive amount of data and just like magic, my module runs very fast and efficient. This little bit of info can be both extremely valuable and scary at the same time. The value is simply that it shows you the amount of data you are dealing with. The scary part is that it can be assumed this is all being written out to disk during runtime. We now know that as long as we're not attaching a Browse Tool to the data at this point, and we deselect the fields we do not need further downstream, we keep our module tidy and efficient! Until next time, - Chad Follow me on Twitter! @AlteryxChad
.NET Framework is a software framework developed by Microsoft that supports the building and running of apps and XML web services. The framework version can have an impact on the installation and operation of Alteryx.
Alteryx is designed to use all of the resources it possibly can. In order to make Alteryx run as fast as possible, it tries to balance the use of as much CPU, memory, and disk I/O as possible. The good news is that most of the resource utilization can be controlled. You can limit the amount of memory that is used on a system, user, or module level. The Sort/Join memory setting is not a maximum memory usage setting; it’s more like a minimum. One part of Alteryx (sorts) that benefits from having a big chunk of memory will take that entire amount right from the start. It will be split between all the sorts in your module, but other tools will still use memory outside that sort/join block. Some of them (e.g. drive times with a long maximum time) can use a lot. If a sorting can be done entirely in memory, it will go faster than if we have to fall back to temp files, so that’s why it’s good to set this higher. But if the total memory usage on the system pushes it into virtual memory, you’ll be swapping data to disk in a much less optimal way, and performance will be much worse and that’s why setting it too high is a bigger concern. The Default Dedicated Sort/Join Memory Usage can be found in the Designer at Options > User Settings > Edit User Settings Best Practices on Memory Settings 32-bit machines*: Setting should be on the lower, conservative side. No matter how much actual RAM is there, only has at maximum 1 GB available, as soon as it is set higher, the machine will cross over into virtual memory and be unable to recover. A 32-bit machine should never have a setting over 1000MB, and 512 is a good setting. Set it low (128 MB), especially when using Adobe products simultaneously with Alteryx. 64-bit machines: Set this in the system settings to half your physical memory divided by the number of simultaneous processes you expect to run. If you have 8 GB of RAM and run 2 processes at a time, your Sort/Join memory should be set to 2GB. You might set it lower if you expect to be doing a lot of memory intensive stuff on the machine besides Alteryx Set your Dedicated Sort/Join Memory Usage lower or higher on a per-module basis depending on the use of your computer, doing memory intensive non-sort work (i.e. large drive-times) then lower it, doing memory intensive sort-work then higher.
*Please refer to this link for additional details on 32-bit support for Designer