Dynamic Input

Solve Query Timeout Issues in Alteryx

A 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 Alteryx

Using An Output as An Input in Alteryx

Using a workflow output as an input in the same workflow can be tricky. How do you make sure the output is completely written before being used as an input? A few months ago, I showed how the CReW macro tool, Parallel Block Until Done, can be used to control the order of operations in a workflow so that the output is fully written before the input is used. The CReW macro creator, Mark Frisch, reached out to me recently to tell me that my solution wasn’t wrong, but that there was a simpler way to achieve the same task. He bestowed some sage Alteryx wisdom upon me, and now I want to share it with you. Thanks Mark! Read on to learn more.

Read More »Using An Output as An Input in Alteryx

How to Create A Dynamic Query in Alteryx

The 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