Alteryx Designer Desktop Knowledge Base

Engine logs are captures of your Results Window and so much more. They can be profoundly useful for troubleshooting, but you have to know how to enable them and how to use them.

The Filter Tool, which is part of the Preparation tool category, separates your data into 2 output streams, True and False, based on a basic filter or custom expression.

The SharePoint connector allows you to use Service Principal for downloading and uploading files, but it requires the Sites.All permission, which gives the user access to all the Sites in the tenant. This article describes how to set it up.

Saving a workflow to Gallery fails with an error if there is a configuration issue with "On Success - Show Results to User" option in the Interface Designer window.

Looking to install additional R packages?  Here's how!

This article explains the steps in configuring the Personal Access Token in Tableau Online server, in order to use this in Alteryx Designer for a successful PAT(Personal Access Token) based connection

You just finished making a workflow, now how do you share it so your colleagues can also use it but with their own inputs? Make an Analytic App!

Alteryx for Excel Users

You may already know how to use the MIN() and MAX() functions to find the smallest and largest values in a list. But what if you needed the second smallest number or 3rd largest number in the list? Excel has a function for this. Using the =SMALL function, you would specify the data range followed by 'x' smallest number you want to find.

This issue appears when an App writes to an Excel document. When the results are displayed and the Excel document opened, it will show as empty. As soon as the Excel document is closed, an Unhandled exception error will display, and the App cannot be closed.

Troubleshooting the error: XmlParse Error (2): the element Configuration is not properly closed.

You're working on your gazillionth Formula tool and "Jeff" from Quality Assurance sends you an email that the margin of error for your process has been restandardized. It's not 0.122 anymore but 0.121. Then the horrible reality sets in - you're going to have to go back through all of your formulas and update that one.. stupid.. little.. number.

Sometimes clients have asked how they can re-input the same excel file that they have just outputted into the same workflow. Normally, their gut instinct would be to open up a new workflow and start fresh with the updated file. However, this can be a bit cumbersome especially if they want to do this multiple times or for those wanting to do some sort of logging process in an app. Luckily, there is a quick and easy trick for this.

Are you tired of your boring old workflow? Just sitting there in your Designer, slacking off?

For any macro or analytic app – one of the inevitable questions that you may encounter is “how do I configure this to do what I need?” For example, if you build a macro that checks if two fields are equal, but sometimes you want to ignore the case such that “A” equals “a,” and sometimes you want an exact match. This is where the Interface Tool Category comes to the rescue, with a super-tool called Check Box!

I recently set up an app that got me One Step Closer to Alteryx Nirvana. Check it out!

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Date Tool on our way to mastering the Alteryx Designer

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!

When setting up manually specified NAME and VALUE parameters in an Alteryx Analytic App there are two options.  When the NAME and VALUE are different, they must be in the format “Name: Value”.  However, if the name and value are the same, you can just type the Name (or Value, they are the same either way).   The Drop Down list would look like this: