Last week, I wrote a blog post on how to fix query timeouts in Alteryx, and part of that solution involved using Detour tools. But, Detour tools are so useful that I thought they deserved their own post. Read on to learn more about how to improve your Alteryx development with Detour tools.
Read More »Speed Up Alteryx Development With Detour ToolsTwo 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 ToolYay! I learned to build batch macros this week! I’ve wanted to tackle batch macros for quite some time but I didn’t have any use cases. This week two use cases popped up. In my first use case, I feed a dynamic query with a batch macro. More specifically, I feed a list of wells into the dynamic query. I’ll show you how to do this in blog and video. Read on to learn more.
Read More »Feed a Dynamic Query with a Batch MacroThe 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