topic DB Connect replacing trailing Zero's? in Getting Data In

DB Connect replacing trailing Zero's?

Gattaca2 — Mon, 13 Mar 2023 13:34:14 GMT

Has anyone seen this before, I'm using DB connect to pull data in from a MySQL db, and this is the results shown in the data lab

but the raw events have the training zero's replaced with E7, any idea how I stop this?

Thanks in advance

Andy

Re: DB Connect replacing trailing Zero's

richgalloway — Fri, 10 Mar 2023 15:56:36 GMT

It's not that the trailing zeroes have been replaced by "E7". The number has been converted to scientific format. There should be functions you can use to ensure the value is returned as an integer ("cast", perhaps). Ask your DBA.

Re: DB Connect replacing trailing Zero's

Gattaca2 — Fri, 10 Mar 2023 15:58:54 GMT

Thanks

I did have a quick look for something like that, I'll go and investigate further.

Andy

Re: DB Connect replacing trailing Zero's

Gattaca2 — Sat, 11 Mar 2023 12:11:02 GMT

Yep a CAST command worked

For anyone who comes across this thread in the future, this solved the problem

CAST(Value AS DECIMAL(12)) as Value

What confused me was it was showing fine in the DB Connect Data Lab, but the data changed when it was ingested.