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?
Solved! Go to Solution.
What is your intended result? 1-4 can't be stored as a numerical value because of the hyphen within the value. For example, what would the expected result if you multiplied this value by 2?
We found a work around on this issue. The consumers of the database we referring to the wrong field.