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.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am creating reports and in many of them I need columns with numbers that don't have the comma separators (store numbers, item numbers). Using the table tool always adds commas to all numbers. Is there a way to get rid of these?
Yes that is easy to do: just change the number field to a string before the table.
One simple trick is to put a select tool before the Table tool and change the type of the specific columns to strings. It will then not add commas
I have tried this but I am exporting these to an excel file for others to use and doing this causes them all to come over as text. This is causing issues when they are attempting to use them for other calculations.
Store Numbers and Item Numbers should (ideally) be treated as strings as they are identifiers as opposed to values.
What kind of calculations are being performed on these values?