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, 2022
- 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,879 views
- Feb 11, 2022
- 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...
208 views
- Jan 20, 2022
- 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...
206 views
- Jan 13, 2022
- 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...
494 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?...
59 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...
192 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. ...
81 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?...
68 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...
83 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...
115 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...
139 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...
263 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...
600 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...
202 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...
87 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...
204 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,813 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...
95 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...
298 views
bottom of page