Alteryx Designer Desktop Knowledge Base

As currently designed, the Amazon S3 Download tool only allows one file, or object, to be read in at a time. This article explains how to create a workflow and batch macro that will read in the list of objects in a bucket and allow you to filter for the file(s) you want using wildcards!

Workflow optimization tips

Using Iterative Macro to generate a list of random numbers

Question I need a macro that takes as input an integer representing the number of seconds the macro needs to wait until allowing the stream of data to continue. My issue is that I have a free account to a data provider that allows me a limited number of data calls per minute. I'd like to make that number of calls and then wait almost a minute and then go to the next set of calls. I've tried to create an iterative macro that will compare the start time to the current time, but so far I've just succeeded in creating a macro that is stuck in an infinite loop.  I've reached the point in any good development project where I think, "I wonder if anyone else has done this already." Answer We have a tool in the Developer category called Throttle that will do what you need.  

Join vs. Append

How to Always Run Alteryx as an Administrator

Configure a Workflow to use a Tree Interface Tool

Can you wait X seconds between processing each row in Alteryx?

How do I pass a parameter/constant in a workflow?

Improving processing speed up to drive time trade areas

Does "Dictionary Sort Order" always place lower case letters before capital letters?

Resources for regression analysis

Alteryx Workflow,

How do you convert a string with a $ sign into a number?

How can you calculate the standard deviation of the population (SDpop) rather than standard deviation on the sample data (SDsample)?

How to connect to a Dropbox or Box.com account from Alteryx on your desktop

Alteryx has the ability to calculate the quarter, week number, etc

How to create a help file/link for your custom Applications and/or Macros

HDFS FAQ

The important thing to know is that when you least expect it, this file can become a lifesaver if something happens to your original workflow, so please don't delete them!

How do I calculate the number of business days between two dates?