We are working on a project that has pre-loaded data and when running it through the select tool, we needed to change 2 different fields from string to Int64. When running the workflow, I received conversion error messages for these fields and my assumption is because those specific data points contain decimals while most other points within those columns are whole numbers.
Would anyone know how to address this? Keep in mind I am fresh to this software and this area in general so I'm not making sense of how a formula or filter tool can help correct this.
Thank you!
you have to remove any thousand separator (,) for conversion i known it sound stupid but it is.
e.g 1,000.00 > 1000.00
The thousand separators were already removed. The only other separators that remain are the decimal points.