Replace Data cleansing tool with Formula tool

[kauser]

Hello, 

i have a big workflow which cause an issue "Memory limit reached. Use a browse tool to view full results" and i was told by expertise if i can replace my cleansing tool with Formula tool then i might resolve the issue. can you suggest me how to resolve these following issues with formula tool instead of cleansing tool- 

1. How to remove Trailing spaces issue with formula tool instead of cleaning tool 

2. How to replace Null cell with 0 with formula tool instead of cleaning tool 

Thank you 
Kauser 

[Bren_Spill · Accepted solution]

@kauser - refer to this post. There are a lot of things you can do to aside from changing all of the cleanse tools to formulas.

Solved: Alteryx workflow - Memory limit - Alteryx Community

As this post mentions, you can use TRIM function to remove leading/trailing white space. 

For nulls, use an if statement: if isnull([Field]) then 0 else [Field] endif. Use a Multi Field tool to apply this logic to multiple columns

[kauser]

@Bren_Spill  

from that article, i used "Try using the Auto Field tool" and its solve my issue. Thanks