topic Re: Transform data type mapping in Qlik Replicate

Transform data type mapping

simonB2020 — Wed, 20 Apr 2022 19:50:09 GMT

I have an MSSQL DB with a lot of floats, and am replicating to S3.
With replicate, that means that the number 153 gets written to csv as +1.5300000000000000e+02
The docs explain the mapping as float > Real8 > Real8(14).
I'm sure that is useful to someone, but it sure isn't me !

Ok, so what to do about it ?

Yes, I could manually set a different datatype in 'transformations', but I have 766 such fields across 430+ tables.
.. and I have 2 databases like this.

Can anyone suggest an easier way than blistering my fingers doing it manually ?

Thanks

Re: Transform data type mapping

KellyHobson — Wed, 20 Apr 2022 20:30:44 GMT

Hey @simonB2020 ,

It's possible to update the query syntax for AmazonS3Syntax in your configuration. Thus you can avoid manual work of setting up the transformations on each table.

This requires editing an important configuration file, so I would open a Support ticket for further assistance.

**Edit 1- Please defer to Swathi's solution. Much more straight forward and safer option. Global Rules -> Transformation -> Convert Data Type then select what you would like to convert to

Best,

Kelly

Re: Transform data type mapping

SwathiPulagam — Wed, 20 Apr 2022 19:58:37 GMT

Hi @simonB2020 ,

You can set it to a different datatype using Global transformation for all the tables once.

Thanks,

Swathi

Re: Transform data type mapping

simonB2020 — Wed, 20 Apr 2022 21:25:56 GMT

Thanks for the solution, works a treat 🙂