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.
Alteryx Community,
I have a zipcode field that I need to export into excel as a numeric field, however Alteryx is adding in the commas into the number field.
Is there a way to export a field out into a .xlsx file as number field - WITHOUT the commas?
I attached a workflow to show you whats happening.
Thanks again for all the help.
Javier
Solved! Go to Solution.
Hi @jdelaguila,
Are you using the reporting tools to create the spreadsheet or are you using an output tool?
I don't need the dashes actually - i figured i could get rid of that using the cleansing tool. I'll be keeping the first 5 digits of the zipcode only.
So i would love to export out the zipcode '22310' as a number instead of '22,310'
Right now i'm using an output tool - but would be okay using the reporting tool if that would fix the problem.
Well thats interesting. So in Alteryx it shows up like this:
But then it exports out like this:
I was assuming my last select tool view was what was going to export - but looking at it in Excel it all looks good. At the end of the day it works. Thanks for the quick response once again!
Javier