IN DB Connection Showing Int. Fields With Commas

[bobokoko1]

Hello,

I just updated my Alteryx Designer to 2021 and i'm noticing that when I run my in db workflow the integer numbers are showing with commas now. Is this something new they changed? We have a lot data that are consider numbers but are really string, but that is how they were built. Like a date would be 20210517, but now it is showing 20,210,517. Is there a way to turn this off, I have an older version of the desktop still installed and it does not show the commas. 

[danilang · Accepted solution]

Hi @bobokoko1 

In the newest versions of Alteryx, you can control the display of thousands separator on the Localization page in the user settings

Dan

[mceleavey · Accepted solution]

Hi @bobokoko1 ,

in addition to what @danilang showed, in the results window you also have a toggle:

M.

[danilang]

Thanks @mceleavey 

I'll have to upgrade at some point to see all this new goodness for myself

Dan

[bobokoko1]

This is great, thank you for this.