We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Anyway to change data type in the table tool?

CDIns
8 - Asteroid

Other than using a select tool and changing the data type before my table tool, is there anyway to change the data type in the table tool via column rule? 

 

My table is currently outputting customer IDs with a comma. For example, 2904 outputting as 2,904. For presentation purposes, I'd like to keep it as 2904. I created a formula in the column rule tostring([CustomerID]) and the workflow runs fine but still outputting as 2,904. 

 

any ideas? 

2 REPLIES 2
binuacs
21 - Polaris

@CDIns one option change the Customer ID data type to v_String using a select tool just before the table tool

OTrieger
14 - Magnetar

Hello @CDIns 

You actually do not want to change the data type, as if you will do so you will lose all the numbers post the "," as Alteryx does not recognize "," as a delimiter. Just add a Formula tool and with the use of Replace function replace the  "," with "".  Then if you want you can change the data type, however you already solved the issue and that step will not be needed any more, unless you will need to have this field in the numeric format.

Labels
Top Solution Authors