I cannot figure out how to format a numeric value, then render it without the "," separators. I do not want it as a Text column, it is a record ID, but It should be numeric so Excel does warn about having numeric content is a text field.
Hi @ScottShimer ,
When transforming a text field with a comma as decimal separator to a double type, you need to select the check box down below the select tool.
Best,
Fernando V.
Hi @ScottShimer , @fmvizcaino
I interpreted this as you are trying to stop comma appearing on your RecordID field when you open it in excel?
Hi @ScottShimer ,
if you're using a Table tool and a Render tool for output to Excel, you have to define a column rule within the Table tool.
Select the field and "Column Rules":
As an option within the column rule, you can define the number of decimal places for output.
The column appears in Excel as a numeric column without decimal places.
Hope, this is helpful.
Best,
Roland
Thanks, Roland, but it is the comma "," I want to get rid of in the output, e.g. 1000 not 1,000.
You are correct, thanks!
Hi @ScottShimer,
I haven't seen a way around this - other than output as string and set your excel smart tag options to ignore numeric strings?
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Removing-commas-from-field/td-p/108216
Hi Andrew, im running into this issue as well, i.e. need the format to be numeric in Excel but i also don't want commas and decimals.
with regard to your suggestion of using ,"excel smart tag options to ignore numeric strings". do you have an article or link i could find how to accomplish this?
This is a problem for me as well. I want years (Int32) to show in a Basic Table without the comma. How? Thanks!
Did you get an answer to this as I have the same issue?