I am always looking for ways to improve efficiency when developing in Alteryx. The Alteryx Browse tool has “hidden” functionality that is often overlooked. Read on to see if you’ve missed this opportunity in the Alteryx Browse tool.
Read More »Have You Missed a Secret in the Alteryx Browse Tool?Of all the tools, the Alteryx Generate Rows tool was one of the last tools I learned to use. I knew it wasn’t hard to use, I just didn’t put in the time because I could usually accomplish the same task with a join. But, it is a super handy tool, so I thought I’d write a quick tutorial on it.
Read More »How to Use the Alteryx Generate Rows ToolA few weeks ago, I wrote a post on how to resolve query timeouts using batch macros. Shortly after publishing, Mark Frisch of CReW Macros reached out to me to say that my post wasn’t wrong (whew!), BUT there is another way to fix query timeouts without resorting to macros. It’s taken me a while to get around to it, but I wanted to share his solution as well. Read on to learn another way to solve query timeout issues in Alteryx.
Read More »Solve Query Timeout Issues in AlteryxLast week, I wrote a post showing how the Auto Field tool could be used to reduce the size of data sets. This week, I’m going to show how the same tool can be used to programmatically remove columns with zeros or nulls. This can also help reduce the size of your data sets and get rid of columns. Read on to learn how.
Read More »Remove Columns with Zeros or Nulls from Alteryx WorkflowsTwo weeks ago, I wrote this post on how to make workflow development more efficient with user constants. It didn’t take long before I ran into limitations with user constants. But, where user constants failed, the Alteryx Detour tool overcame. Read on to learn how the Alteryx Detour tool can speed up workflow development.
Read More »Speed Up Query Time with Alteryx Detour ToolI’m new to most of the Reporting Tools, and I ran into a problem recently where the Alteryx Report Text Tool strips out punctuation. There are two simple solutions to this problem. Read on to learn more.
Read More »Report Text Tool Strips Out PunctuationOn Monday, I said I would share two Alteryx tips and tricks learned from coworkers. The first tip was from Alice Yu, who showed me that it’s possible to use the In operator in Alteryx Filter tools. The second tip comes from Jack Stewart, who is replacing Alice on our Analytics team. Jack helped me out on a particularly sticky regex problem. I wanted to showcase his solution because it shows how to use Find and Replace tools to simplify regex. Anytime I can make regex simpler, I am all for it. Read on to learn more.
Read More »Use Find Replace Tools to Simplify RegexOne of the things I love about Alteryx is how fast it pushes data through a workflow. However, sometimes, we need to run one part of a workflow before another. In other words, we want to control the order of operations in Alteryx. I knew the application could do this, but to incorporate it into my workflow, I had to learn a few new tools. Read on to learn which tools allow you to control the order of operations in a workflow.
Read More »How to Control the Order of Operations in AlteryxThe more I learn about Alteryx, the more I love it as a tool for data wrangling. I recently had 2 use cases pop up where I needed to be able to dynamically change the data being queried. I knew the application could perform this task, but I hadn’t yet learned how to create a dynamic query in Alteryx. Now that I know how I’m writing it up for future reference and other people to use. Two use cases are presented because they are configured differently. Read on to learn how.
Read More »How to Create A Dynamic Query in Alteryx