Hi Zuar -
I have an XLS that is being successfully ingested into Mitto via an rClone job.
One of the columns I am picking up from the XLS contains decimals. These decimals are SHOWING as integers in XLS. If I expand the # of decimal places to show in XLS, I can see there are indeed decimals.
In Mitto, I use an io job to change the XLS sheet to a table in Postgres.
The problem is when I query the table in Postgres, it isn’t picking up any of the decimal places that are in the XLS. Rather, it is assigning a data type of “int4”.
When I try to cast the field in the Mitto [SQL] job (using ::numeric) – the data type updates to show it is indeed a numeric – but only shows .00 for decimals – in other words, it is still really an integer.
Q: How do I get Mitto to pick up decimals in the XLS file (even if they are formatted to not show) and show the exact, equivalent number in Postgres?