IF ElSEIF Statement Tip
This tip was suggested by a friend of mine Will Perkins. Thanks Will! Have you ever written an IF ELSEIF statement for criteria between...
top of page
Mar 2, 20222 min read
Simple REST API JSON Example
Have you heard of pulling data from API? In a previous Tableau blog post here, I am taking a course on API. Wikipedia defines API as "An...
2,848 views
Feb 11, 20222 min read
Using the Find Replace Tool Instead of a Left Outer Join
Did you know that sometimes it is faster to use a Find Replace Tool instead of using a Join Tool with a Union Tool for a Left Outer Join...
474 views
Jan 20, 20222 min read
Writing Out to Multiple Excel Tabs or Multiple Excel Spreadsheets
What if you client wants to have separate tabs for different months in the same excel spreadsheet? What if they want them in different...
264 views
Jan 13, 20222 min read
Multi-Row Formula Tool - Calculating a Moving 12 Months
Do you need to calculate a total value for the last 12 months? If you have data from January - December, you can use the Summarize Tool...
931 views
Dec 10, 20212 min read
Find Replace Tool with Comic Book Characters
Do you have part of a phrase in a column and you just need to replace one word? What if you wanted to add another word in that same cell?...
95 views
Dec 2, 20212 min read
Add a Hyperlink in Alteryx
Did you know you can add a hyperlink to your dataset in Alteryx? This tip was suggested by Nicolas Colombo. Thank you Nicolas! This...
917 views
Nov 18, 20211 min read
Bingo Cards in Alteryx
Have you ever wondered how to generate Bingo cards? For an upcoming wedding there are various bingo activities such as meet the guest. ...
107 views
Oct 28, 20211 min read
Forgot to Annotate?
Do you have a workflow with a lot of different tools, say 100+? What if you forgot to document some of these tools for controls purposes?...
114 views
Oct 19, 20212 min read
Where Have All the Formulas Gone?
Do you need to create a calculated field and you aren't sure which formula to use? Did you know that Alteryx lists all of the available...
111 views
Oct 8, 20211 min read
Optimize Your Workflow
Do you want to make your workflow run faster? Below are a couple of tips to optimize the performance of your workflow. Did you know that...
149 views
Sep 24, 20212 min read
Sample Tool vs Random Sample Tool
Do you need to pull a sample of data from a large dataset to validate formulas? Here are two tools in Alteryx that can pull from your...
344 views
Sep 9, 20211 min read
A Few Helpful Alteryx Formulas
There are so many different Formulas (or Functions as found in this helpful reference article here.) in Alteryx. Below are just a few...
486 views
Sep 2, 20212 min read
How to Add Grand Totals to Your Data
Have you ever wondered how to add Subtotals and Grand totals to your data set? Here is one method; In this example I start out with the...
941 views
Aug 27, 20212 min read
The Directory Tool
Have you ever wondered why you would use the Directory Tool? This tool provides a listing of all the files in a specific directory (or...
360 views
Aug 5, 20212 min read
What is the Fuzzy Match Tool?
Have you ever wondered what this complex tool does? It can help to identify non-identical duplicates in a column. What are...
110 views
Jul 29, 20212 min read
What's the Difference Between the Append, Join and Union Tools?
When I teach Alteryx to new users, this is a question that comes up a lot. I modified the below picture from the internet to help...
706 views
Jul 23, 20212 min read
Using the Render Tool to Export to Different Sheets in the Same Workbook
As a follow up to last week's tech tip, I was asked how do you export to different worksheets in the same Excel workbook using the Render...
3,252 views
Jul 15, 20211 min read
Write a Document to SharePoint Library Using the Render Tool
I get questions all the time about Alteryx and SharePoint. I just learned this trick. You can use the Render Tool to write out to a...
130 views
Jul 6, 20211 min read
Block Until Done Tool
Have you ever tried to open an excel spreadsheet and received a message that another user is in the workbook? Every time an excel...
692 views
bottom of page