Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.
View full article
You may already be aware of a function that allows you to find the difference between two dates. It's the DATETIMEDIFF() function and you can use it in any tool that allows you to write an expression
View full article
Rather than copying and pasting this process from workflow to workflow, I decided to create a macro (and this macro doesn’t require any configuration!) and make it available to a wider audience with the hope that it will save time and energy by eliminating the need to recreate the process of translating a date week number, quarter, etc.
View full article
This article is part of the CS Macro Development Series. The goal of this series is to communicate tips, tricks, and the thought process that goes into developing good, dynamic macros.
View full article
Interested in getting an email notification whenever a workflow is executed and fails? Read this article for a detailed guide.
View full article
Suppose you have a datetime stamp in a dataset for the timezone where you are. This dataset includes data for locations in timezones other than the one you're in and you want to convert your datetime stamp to reflect the local time zones of the locations in your data.
View full article
So you’re new to Alteryx, you’ve downloaded and installed Alteryx Designer, you’ve rolled up your sleeves and you’re ready to go. Everything is going along swimmingly and wham! You run into a wall. Why isn’t that tool working correctly? Let’s take a look at the primary product training and support resources available for Alteryx and see if we can get your workflow working the way it should.
View full article
Sometimes large amounts of data can 'overwhelm' a tool or process in your workflow and make it appear like it is stuck or frozen.  This was the case recently when a user attempted to pass 7 million rows of data to a CASS tool.  Splitting these records into smaller chunks makes the process run much quicker. 
View full article
You may have noticed that the Cross Tab tool will insert underscores in your headers.
View full article
Steps for Harvesting Data in Google Big Query!
View full article
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.
View full article
To find the full path and filename of a saved file in Excel, you use the =CELL function.
View full article