Formatting thousands separator in Table tool

[AndreaVaresi]

Dear All,

I need for your help, please! 🙏  In my workflow, I get an Int64 DataType field formatted without of thousands separator (i.e. 35455) but  when I use the "Table Tool"  the data appear with a "," (comma) thousands separator format (i.e. 35,455).🙄

So, what I would get is a Int64 DataType with blank space (i.e. 35 455). 🤔

Dear Alteryx Angel, could you help me? 😇

Thank you in advance for your time!

Greetings

Andrea

[binuacs · Accepted solution]

@AndreaVaresi I think adding a thousand separators on the numeric field is the default property of the table tool. Are you not expecting a thousand separators in your result?

[AndreaVaresi]

@binuacs Thanks a lot for your feedback. I would get another format: 35 455 (one blank space rather then the comma separator)

[binuacs]

@AndreaVaresi would you able to upload a sample workflow to test? 

[realdaniel1989]

@AndreaVaresi 

Based on the image that you posted, it looks like the result pane that is not showing the numerical separator. 

You could have turned off the numerical separator.  Refer to the gif that I have attached to see if this fixes things for you. 

[caltang · Accepted solution]

Hi @AndreaVaresi 

What you are trying to do is to change the Thousands separator. You need to change it via User Settings:

 

[caltang · Accepted solution]

Please be mindful that this change will affect your workflows. Change it back to "," accordingly when you need to do so. If you get stuck, just click on Restore Defaults as such:

 

[AndreaVaresi · Accepted solution]

Thanks a lot for your suggestions.

Greetings

Andrea

[caltang]

Hi @AndreaVaresi - did my suggestion help? Could you kindly mark my comment as the accepted solution?

Thanks,

Cal