In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formulas

jlfromm
8 - Asteroid

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

 

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

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

jlfromm
8 - Asteroid

Does the Data type need to be need to be?

jlfromm
8 - Asteroid

Got it thanks 

alexnajm
18 - Pollux
18 - Pollux

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

Labels
Top Solution Authors