Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
If the API that you are working with requires you to sign or authenticate your requests, it may utilize an implementation of OAuth 2.0 or another authentication method to show that you have the access needed to consume the web service. There are some key words that you can look for in the API documentation that you are using that will help you quickly choose the appropriate grant flow to use in Alteryx.
View full article
Now you are ready to take your workflow one step further and add some error checking. If something is wrong with your request or something goes wrong on the server, an API will usually return an error message. It is useful to capture this information and clearly display it to the user of the connector. The Message tool will come in handy here. It will help you to troubleshoot the error and actually stop the workflow from processing if you would like.
View full article
Alteryx can use the Run Command Tool to run Powershell scripts and perform any Powershell specific commands. Note that in order to run PowerShell scripts you must make sure you have scripting enabled. You should consult with your IT department to see if you are allowed to enable this functionality.\n  
View full article
Have you ever tried writing to multiple tabs within the same workflow and have received an error? This article is for you!
View full article
The attached macro will use the Field Info Tool and a formula to calculate the Excel column letter, e.g., for 755th field, the returned letters would be "ACA."
View full article
For Python-based tool developers, a guide to including wheel files within your tool installer.
View full article
With the Python Tool, Alteryx can manipulate your data using everyone’s favorite programming language - Python! Included with the tool are a few of pre-built libraries that extend past even the native Python download.
View full article
Alteryx Designer comes with tools (based on both R and Python) to create and use predictive models without needing to write any code. But what if you've got custom models written in R or Python outside of Designer that you want to use in Designer, or vice versa?
View full article
A product idea recently introduced the ability to compare workflows using the command line from Windows. I thought it would be good to turn this idea into a more GUI friendly Alteryx Analytic App!
View full article
Learn about the new 20.4 changes to Python.
View full article
Many skunk works type of products are never really seen by the public eye (such as the Boeing Joint Strike Fighter prototype).  The beauty of being a part of a software company that has both desktop and web products is that we have the ability to play with and show off our prototypes to the general public.  Enter interactive visualizations within Alteryx!   (NOTE: The methods described in this article and the linked blog posts serve the sole purpose to display the flexibility of Alteryx and there is no current or future plan to further develop or productize this functionality.)   The image you see above was directly pulled from an Alteryx output.  You may or may not have read the blog of our CTO, Ned Harding (If you haven't, I highly recommend subscribing!).  His recent posts revolve around a topic that has been brought up quite often in the Alteryx circles, reporting and visualizations within Alteryx.   In these articles, Ned displays a method to incorporate HTML5 and Javascript into a few macros with incredible results.  The first is a more static but visually pleasing output, while the second is a Public Gallery app that displays the use of interactive output.  Both are very interesting displays of the two technologies working in tandem to help the user better understand their data. Check it out, test it out, and visit the links to the Public Gallery within the blog.   Part 1: Alteryx: JSON Data Output   Part 2: Alteryx: HTML5 Visualizations   Part 3: Alteryx: Interactive HTML Visualizations
View full article
My code runs in R, but not in the R Tool?
View full article
Tired of pulling conversion rates manually? Me too!   Let’s build ourselves a currency converter in Alteryx Designer version 10.1 using the http://fixer.io/ exchange rates. Fixer.io is a free JSON API for current foreign exchange rates published by the European Central Bank. The rates are updated daily around 3PM CET.   The first thing we will do is gather the API documentation from the Fixer.io website. This will give us the URL we need to make our REST API call. If you are unfamiliar with making REST calls please take a look at Tasha’s
View full article
As currently designed, the Amazon S3 Download tool only allows one file, or object, to be read in at a time. This article explains how to create a workflow and batch macro that will read in the list of objects in a bucket and allow you to filter for the file(s) you want using wildcards!
View full article
Question I need a macro that takes as input an integer representing the number of seconds the macro needs to wait until allowing the stream of data to continue. My issue is that I have a free account to a data provider that allows me a limited number of data calls per minute. I'd like to make that number of calls and then wait almost a minute and then go to the next set of calls. I've tried to create an iterative macro that will compare the start time to the current time, but so far I've just succeeded in creating a macro that is stuck in an infinite loop.  I've reached the point in any good development project where I think, "I wonder if anyone else has done this already." Answer We have a tool in the Developer category called Throttle that will do what you need.  
View full article
Can you wait X seconds between processing each row in Alteryx?
View full article
How do I pass a parameter/constant in a workflow?
View full article
Use a constant to simplify your production moves, minimize the effort to making updates to your workflow tool configurations
View full article
This article details how to enable the logs for the installation of tools written with Python SDK.
View full article
What happens when one installs the YXI file of a Python-based tool in Alteryx Designer.
View full article