Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Programmatic Detour

I've seen this question before and have run into it myself.  I'd like to see a new tool that would allow a developer (of a workflow) to choose a path of logic based upon criteria known only during the execution of a module.


If LEFT INPUT Count of records < 10,000 THEN Path1 (e.g. use a calgary join)

ELSE Path 2 (e.g. use a standard join)







You would have to build it out.


This is how I do it... This is ran every minute in scheduler and checks the timestamp of a query to see when the last refresh was... 

I have a saved file on a shared drive that will save the last time stamp. If the time stamps are different it runs the flow, else it doesn't do anything. If you need to pass data to the open close container macro just add a macro input and pass the data to it.


I would obviously rather have a built in function. This is along the lines of being able to use 2 streams of data to interact with eachother. Example, query pulls in current quarter, then you have other data that has quarters and want to find the min year-qtr of those. Then have the ability to have a filter taking in these single parameters to filter out a bigger dataset. I think its quite odd this isn't already in alteryx. This type of logic that is being asked for is pretty similar to the above suggestion and shouldn't have to be done globally with chaining macros.


It would also be nice if I could just use open and close and have an input that allows me to choose what I'm trying to open and close so I don't have to make a custom open and close container for every scenario (kind of like a parameter in programming and telling it a method or function to call if t or f.)