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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
In the input file we have leading zero in one of the column but the same is missing in the output file. we are not doing any manipulation with this field. The output file is generated in csv format. Please let me know what change need to be done to keep the leading zero in the output file.
This happens because Alteryx interprets the input 01234 as a number and removes the leading 0. Before your output, you'll need to convert the field to a string and use a formula tool to padleft([fieldname],"0", x) where x is the required length
I can verify that all the suggestions provided do work. As mentioned by @danilang , opening the CSV in Excel removes the leading 0's while opening the CSV in a notepad editor does show the zeros. Thank you everyone for your solutions!