This tip was suggested by a friend of mine Will Perkins. Thanks Will! Have you ever written an IF ELSEIF statement for criteria between...

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...

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...

What if you client wants to have separate tabs for different months in the same excel spreadsheet? What if they want them in different...

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...

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?...

Did you know you can add a hyperlink to your dataset in Alteryx? This tip was suggested by Nicolas Colombo. Thank you Nicolas! This...

Have you ever wondered how to generate Bingo cards? For an upcoming wedding there are various bingo activities such as meet the guest. ...

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?...

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...

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...

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...

There are so many different Formulas (or Functions as found in this helpful reference article here.) in Alteryx. Below are just a few...

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...

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...

Have you ever wondered what this complex tool does? It can help to identify non-identical duplicates in a column. What are...

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...

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...

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...

Have you ever tried to open an excel spreadsheet and received a message that another user is in the workbook? Every time an excel...