Data Cleansing Tool Not removing Leading Whitespace

[PPillai]

Hi, 

Any one experienced that Data Cleansing Tool not removing the Leading Whitespace in Alteryx Server.

I have a workflow which uses the Data Cleansing Tool to remove the Leading whitespace. The workflow works correctly when I run from the Alteryx Designer, but when the workflow run from the Alteryx Server Schedule the the Leading whitespace is not getting removed.

The Alteryx Designer version is 2019.3.2.15763

The Alteryx Server Version is 2020.2.3.27789

Kind Regards

[TheOC · Accepted solution]

hi @PPillai 

I cant see why this would happen, and at this moment I do not have my server online to give it a test for you I'm afraid.

What i can suggest is try giving a formula tool, with trimleft() a try. This will do the same thing, and might help at least until someone has a full solution!

I've attached my workflow showing it working

[PPillai]

@TheOC 

Thank you. I am fine with the Formula tool, but we have a lot of workflows uses the Data Cleansing tool and it worked fine in the designer, but now when we moved them to server we are having this issue.