Anyway to change data type in the table tool?

Question

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?

OTrieger · Answer

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.

binu_acs · Answer

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