Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formulas

jlfromm
8 - Asteroid
‎02-29-2024 07:28 AM

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

 

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux
‎02-29-2024 08:08 AM

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

Reply
0 Likes
jlfromm
8 - Asteroid
‎02-29-2024 08:13 AM

Does the Data type need to be need to be?

Reply
0 Likes
jlfromm
8 - Asteroid
‎02-29-2024 08:14 AM

Got it thanks 

Reply
0 Likes
alexnajm
18 - Pollux
18 - Pollux
‎02-29-2024 08:28 AM

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

Reply
0 Likes
GenAI Contest Form
Data Connection Manager
Labels
Top Solution Authors
View All