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 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.
Go to Solution.
Go to Solution.
Hello @jdelaguila ,
What about the numbers with the dash in between?
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.
I actually don't have the issue with the normal output tool. Here is what my output looks like using the attached workflow. Can you show what yours looks like?
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!