Formula Removing Leading Zeros

[Adam_B]

Hello, 

I have a column that Alteryx is adding in leading zeros, this field, when opened in excel, does not have the zeros, I'm sure there's an explaination why Alteryx is adding zeros.  However, my question is regarding the formula I am using to remove said zeros.  It's not working and I don't know why, I have added brackets and parenthesis where appropriate. 

Below are examples of the formula I am using and an example of the data. 

Please help. 

[ShankerV]

Hi @Adam_B 

It is due to the datatype issue.

Trimleft will work on String types, but the column you are using in Integer type.

To overcome the issue, use the below formula

Tonumber(Trimleft(tostring([column name]),"0"))

Many thanks

Shanker V

[Adam_B]

I changed it to an integer and it still gives me the error. 

[ShankerV]

Hi @Adam_B 

Please use the below formula.

Tonumber(Trimleft(tostring([Field1]),"0"))

Many thanks

Shanker V

[Adam_B]

@ShankerV  Still not working

[ShankerV · Accepted solution]

Hi @Adam_B 

Got your issue, this is because of the column name.

Trimleft([[REQ] Supplier (Common Supplier ID)],"0")

The column name contains the [].

Have tried the column name without [], then the formula works fine.

Many thanks

Shanker V

[Adam_B]

@ShankerV Thank you!