Help with Correcting Conversion Errors
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you have to remove any thousand separator (,) for conversion i known it sound stupid but it is.
e.g 1,000.00 > 1000.00
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The thousand separators were already removed. The only other separators that remain are the decimal points.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
