This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm not sure of a way to prevent this from happening through the input tool as those zeroes are likely present in some way in your CSV file. However, you can always trim the zeroes off after the input tool using a formula. A simple TrimLeft formula should get your data formatted the way you'd like. An example is below.
@helenjin1 Try opening your csv in notepad to check if it has leading zeros. Perhaps excel is recognizing that column as numeric and removing leading zeros. Alteryx reads everything in a csv as a string.
Excel is funny (hahahaha). It gives you the ability to mask the field and doesn't differentiate from the value to the mask in what is displayed. Say you read the data as an amount, you could see $1,234.00 but the real data was 1234. In this case, I think that there is a "General" mask for the column. It recognizes all the values as numbers (strings can start with a 0, while numbers can't).
If you change the data type to a NUMBER (e.g. Double or INT64), you'll see the leading 0's disappear. But be careful, if there are empty or spaces or missing values, they will convert to 0.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
AS @patrick_digan suggested, it's not Alteryx that's adding zeros, it's Excel that's removing them. Take the step to examine your CSV in Notepad or another text editor and you'll see that alteryx is importing your data exactly as it is in the file.