Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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!

Reporting Table - Numbers without comma seperators

OSperez
5 - Atom

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?

Inactive User
Not applicable

Yes that is easy to do: just change the number field to a string before the table. 

jdunkerley79
16 - Nebula
16 - Nebula

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

OSperez
5 - Atom

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. 

JoshKushner
12 - Quasar

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?

Labels