Alteryx Flow - Cleans not Completing

My understanding was that when a Green Box appeared around a tool, it was completely finished. In this flow, several of my cleans are showing 0%, yet the tools around them are green. I have attached one example, i'm not sure what is causing this. The flow is also taking super long to complete. Any ideas?

Alteryx Flow Issue..PNG

Optimization

Accepted answers

CharlieS

The green boxes, bold connection lines, and percent notes are only estimates of the processes going through the engine. If you would like to be sure one process is complete before another begins, use a Block Until Done tool.

There are many reasons why a workflow might be running slowly, the best way to find out why is to use the Performance Profiling feature. From the Workflow Configuration, go to Runtime > Enable Performance Profiling. The next time you run the canvas, the Results window will output an ordered list of the tools that tool the longest time to run. If you need help with suggestions on those tools, post up and let us know.

All comments

T_Willins

Hi @AlteryxUserFL,

This post looks like it answers your question:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Order-of-Completion-of-Tools/m-p/397387#M72949

As for workflow performance and without seeing the entire workflow or the data, the data cleanse evaluates each item separately; a large number of rows and fields and/or are cleansing multiple types of characters can lead to longer run times. If possible, limit the data cleanse to only necessary fields and data cleanse types and see if that helps.

ScottG

Turning on Performance Profiling will be useful in determining bottlenecks in the workflow too.

CharlieS

stuabs19

I replaced a data cleanse tool with four formulas of the form IIF ( isnull ( [number field] ) , 0 , [number field] ) ). With the data cleanse, the workflow took almost five hours. With the formula tool and those four formulas, it took 19 minutes.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703