Mar 22 minSimple REST API JSON ExampleHave 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...
Feb 112 minUsing the Find Replace Tool Instead of a Left Outer JoinDid 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...
Jan 202 minWriting Out to Multiple Excel Tabs or Multiple Excel SpreadsheetsWhat if you client wants to have separate tabs for different months in the same excel spreadsheet? What if they want them in different...
Jan 132 minMulti-Row Formula Tool - Calculating a Moving 12 MonthsDo 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...
Dec 10, 20212 minFind Replace Tool with Comic Book CharactersDo 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?...
Dec 2, 20212 minAdd a Hyperlink in AlteryxDid you know you can add a hyperlink to your dataset in Alteryx? This tip was suggested by Nicolas Colombo. Thank you Nicolas! This...
Nov 18, 20211 minBingo Cards in AlteryxHave you ever wondered how to generate Bingo cards? For an upcoming wedding there are various bingo activities such as meet the guest. ...
Oct 28, 20211 minForgot 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?...
Oct 19, 20212 minWhere 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...
Oct 8, 20211 minOptimize Your WorkflowDo 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...
Sep 24, 20212 minSample Tool vs Random Sample ToolDo 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...
Sep 9, 20211 minA Few Helpful Alteryx FormulasThere are so many different Formulas (or Functions as found in this helpful reference article here.) in Alteryx. Below are just a few...
Sep 2, 20212 minHow to Add Grand Totals to Your DataHave 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...
Aug 27, 20212 minThe Directory ToolHave you ever wondered why you would use the Directory Tool? This tool provides a listing of all the files in a specific directory (or...
Aug 5, 20212 minWhat 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...
Jul 29, 20212 minWhat'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...
Jul 23, 20212 minUsing the Render Tool to Export to Different Sheets in the Same WorkbookAs 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...
Jul 15, 20211 minWrite a Document to SharePoint Library Using the Render ToolI 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...
Jul 6, 20211 minBlock Until Done ToolHave you ever tried to open an excel spreadsheet and received a message that another user is in the workbook? Every time an excel...
Jun 15, 20211 minForgot to Save? No problem!Did your computer shut down and you forgot to save the workflow you were working on? Did you know that similar to Microsoft Office...