data type in table tool

Question

Hi Alteryx savvy,

I'm using the table tool to create a report. Is it possible to change the data type? It's fine for those amounts to have a comma, but I'm seeing a comma in the year column. How can I remove the comma from the year column?

Thanks,

Jocelyn

Capture.PNG

DataNath · Accepted Answer

Hey @Jocelynupup, if you just change that field to a String data type before the table in a Select tool, that should remove the comma.