Alteryx Designer Knowledge Base

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?

When bringing data into Alteryx a lot of users often add a select tool to check the data type and structure. Data types are very important because of the available operations/functions in tools can be adjusted to fit the data type being used!

How to create a help file/link for your custom Applications and/or Macros

The important thing to know is that when you least expect it, this file can become a lifesaver if something happens to your original workflow, so please don't delete them!

You have gone through the hard work of creating your macro and now want to make it easy to insert this into your workflow time and time again. You may have, up until this point, been right clicking on the Alteryx Canvas and going to Insert>>>Macro.    However, you can now create your own macro category by going to Options>>User Settings>>Edit User Settings     Within this splash screen you should now be able to see a macros tab:     At this point you can hit the '+' icon and you can give a name to your category and select the file folder where you save your macros in.    Then simply press Apply and OK and the new tool category will appear at the end of your tool palette.    Best, Jordan Barker Solutions Consultant

In some cases Designer is very slow when working from home. This can have several root causes.

Error connecting to Office 365 using the Sharepoint Input tool - "The sign-in name or password does not match in the Microsoft Account system", when the user tries to connect to Sharepoint from the Alteryx Designer

Quick Connect: Internal-Error-Unable-to-add-new-Alias-to-the-Alias-Manager

The error message appears when using System Settings in Alteryx Designer.

If you are unlucky 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. 

How to add your username into the results of your workflow

This error occurs when importing a Gallery Data Connection, but there is an issue with the Gallery Data Connection.

There is a comprehensive list of Data Sources Alteryx Designer / Server can connect to. While only these are supported you still might be able to build your own connector. Additionally a product feature can be requested.

Full details on the addins can be found on my blog; the addins can be download from GitHub. Hopefully it will make creating some formulas easier!

Performance tuning is an art.  Start sketching today!

So you've installed the licenses to run Scheduler. Now what?

If you observe an error message like Error: Salesforce Input (1) File " ", line 1 os.environ['PATH'] = r"... please read on to learn how to adjust the environment variables to resolve it. This can happen with any one of several Connector tools, not just the tool mentioned in the example.

An "Unhandled Exception" thrown when starting Designer, appears when the user clicks on the splash screen. Looking at C:\ProgramData\Alteryx\ErrorLogs reveals the following error type: System.IO.DirectoryNotFoundException Message: Could not find a part of the path 'F:\.....'

Understanding Join output anchors and when to add a Union tool:  The Join tool anchors are separate subsets of data. You can combine them with a Union tool. The Select functionality of the Join tool applies only to the J anchor, not the R or L anchored data.

This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.

For problems with Windows not launching Designer or displaying an error message, the Program Compatibility Troubleshooter may help.