Formulas

[jlfromm]

I have a data set that has nine digits in it when end my excel file. When I bring it over to Alteryx i am loosing the leading zeros. What can I go to make sure they come over. 

Here is my sample 

Excel file shows 

000000304

000004318

000005085

When it comes over in Alteryx it is showing 

304

4318

5085

[alexnajm · Accepted solution]

Padleft([Column],9, “0”)

[jlfromm]

Does the Data type need to be need to be?

[jlfromm]

Got it thanks 

[alexnajm]

Yes it needs to be a string to store leading zeroes!