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...
- Mar 2
- 2 min
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...
1,086 views
- Feb 11
- 2 min
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...
136 views
- Jan 20
- 2 min
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...
194 views
- Jan 13
- 2 min
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...
301 views
- Dec 10, 2021
- 2 min
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?...
55 views
- Dec 2, 2021
- 2 min
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...
103 views
- Nov 18, 2021
- 1 min
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. ...
69 views
- Oct 28, 2021
- 1 min
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?...
64 views
- Oct 19, 2021
- 2 min
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...
80 views
- Oct 8, 2021
- 1 min
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...
102 views
- Sep 24, 2021
- 2 min
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...
43 views
- Sep 9, 2021
- 1 min
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...
220 views
- Sep 2, 2021
- 2 min
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...
463 views
- Aug 27, 2021
- 2 min
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...
130 views
- Aug 5, 2021
- 2 min
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...
78 views
- Jul 29, 2021
- 2 min
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...
62 views
- Jul 23, 2021
- 2 min
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...
1,194 views
- Jul 15, 2021
- 1 min
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...
91 views
- Jul 6, 2021
- 1 min
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...
137 views