Replace Data cleansing tool with Formula tool

Question

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_Spill2 · Accepted Answer

@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