community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Data Cleansing Speed

Hello all,

 

I have noticed that the Data Cleansing tool is quite heavy on processing time within a typical workflow, and I would like to know:

 

  1. What is quicker: using the Data Cleansing tool or doing the same cleansing tasks with the Formula / Multi-Field Formula tools?
  2. Generally speaking, what is the quickest, lightest way of achieving what the Data Cleansing tool does?

Thanks in advance for any opinions, etc.

 

Regards

Richard

Alteryx Certified Partner
Alteryx Certified Partner
The data cleansing tool is a macro. You can open it up and see all of the tools inside. Using a single multi field tool or set of tools should be faster., if for no other reason than less overhead.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted

Hi Mark

 

Thanks for that, I have opened up the macro and can see it is a chained series of Multi-Field Formula tools, doing "IF IsNull() THEN 0" style operations.

 

As a follow-up question, and the answer probably is yes, but is this Formula approach literally the quickest way of replacing Null values with 0 in numeric fields?  

 

Thanks

 

Regards

Richard

Labels