Alteryx Designer Knowledge Base

Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.

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

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.

How to Change Single Quotes to Double Quotes

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.

Multiple Excel Files to One Excel File

Interested in getting an email notification whenever a workflow is executed and fails? Read this article for a detailed guide.

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.

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.

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. 

You may have noticed that the Cross Tab tool will insert underscores in your headers.

Run Command

Steps for Harvesting Data in Google Big Query!

Alteryx for Excel Users

Alteryx for Excel Users

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.

Alteryx for Excel Users

Alteryx for Excel Users

To find the full path and filename of a saved file in Excel, you use the =CELL function.

How to dynamically generate reports, based on the grouped data?