Upload Connector - Field with "%" in it coming over as scientific notation (E-)
Hi! So I have a bunch of spreadsheets that I'm loading into Domo using the Upload Connector. These are far from ideal and are manually populated by users but it's the world I'm living in right now.
The problem I ran into today is there is one set of fields where the field in Excel contains a value with a % symbol keyed into it (not just displaying in the formatting but actually stored in the field) Example "6.4%"
When I pull the data into Domo using the Upload Conenctor the field is coming over as "6.400000000000001E-2" which is subsequently causing it to read it as a text field in my ETL and throw an error when I try to convert it to decimal (this was previously working fine before I started pulling in this new field).
I have an idea of a sort of cumbersome way to solve for this in my ETL (see below) but wanted to check in here and see if anyone else has run into this and has a more elegant solution (or thinks this is really a defect that I should open for Domo to look at).
Here's my idea:
1. Split the field into two columns using the decimal as the delimiter
2. Use text operations to strip out all non-numeric values (including the E and -)
3. Combine columns using decimal as the separator
4. Set Column Type to decimal