Formatting thousands separator in Table tool

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

Issue_print.jpg

Reporting

Preparation

Accepted answers

binu_acs

@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?

caltang

Hi @AndreaVaresi

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

Screenshot 2023-06-30 111504.png

Screenshot 2023-06-30 111604.png

caltang

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:

Screenshot 2023-06-30 111754.png

AndreaVaresi

Thanks a lot for your suggestions.

Greetings

Andrea

All comments

binu_acs

@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

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

binu_acs

@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.

AlteryxGui_GKgiDkguQ9.gif

caltang

Hi @AndreaVaresi

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

Screenshot 2023-06-30 111504.png

Screenshot 2023-06-30 111604.png

caltang

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:

Screenshot 2023-06-30 111754.png

AndreaVaresi

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

BaDaBoom

just an FYI, this will NOT apply to data in the results grid.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235