community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Reporting Table - Numbers without comma seperators

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?

Highlighted
Alteryx Certified Partner

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

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. 

Bolide

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