Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simonB2020
Creator
Creator

Transform data type mapping

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

Labels (3)
1 Solution

Accepted Solutions
SwathiPulagam
Support
Support

Hi @simonB2020 ,

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

Thanks,

Swathi

 

View solution in original post

3 Replies
KellyHobson
Support
Support

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 

SwathiPulagam
Support
Support

Hi @simonB2020 ,

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

Thanks,

Swathi

 

simonB2020
Creator
Creator
Author

Thanks for the solution, works a treat 🙂