I am successful in writing to Access and creating a table. My problem is certain fields need to be formatted so users can do calculations. For example, I have a field with client size and there are several groupings 1-4, 5-9, 10-19, etc. I have tried to change to double but Alteryx changes the grouping to a single number 1-4 goes to 1 and 5-9 goes to 5 etc.
What format can I use to write to an access table where the consumers of the data can do a calculation on the field?
