IN DB Connection Showing Int. Fields With Commas

Question

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 Answer

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 Answer

Hi @bobokoko1 ,

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

M.