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

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.yxmd