Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Learner1
Contributor III
Contributor III

Qlik replicate-trim spaces for postgres source point

Hello team,

We have created two qlik jobs; source point is postgress for both, and endpoints are oracle table and kafka topic respectively.

The leading/ trailing spaces in postgres are replicated correctly to oracle table but in the kafka event, they are trimmed.

Could you please let me know the setting which can be changed.

 

Thanks in advance !

Labels (2)
2 Solutions

Accepted Solutions
john_wang
Support
Support

Hello @Learner1 ,

 

We got similar report recently. please check and let me know if you need additional assistance.

https://community.qlik.com/t5/Qlik-Replicate-Discussions/Spaces-in-same-treated-differently-accordin...

 

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

Learner1
Contributor III
Contributor III
Author

Absolutely... thanks a lot.

View solution in original post

4 Replies
john_wang
Support
Support

Hello @Learner1 ,

 

We got similar report recently. please check and let me know if you need additional assistance.

https://community.qlik.com/t5/Qlik-Replicate-Discussions/Spaces-in-same-treated-differently-accordin...

 

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Learner1
Contributor III
Contributor III
Author

Absolutely... thanks a lot.

john_wang
Support
Support

Hello @Learner1 ,

Glad to hear that.

Can I know what's your Replicate version? I cannot reproduce the behavior (missing trailing spaces in Kafka) by Replicate Nov 2020 (version 7.0) + PostgreSQL Server v11 + psqlodbc v13 + Kafka v2.6 (2.13-2.6.0 ).

Your versions information are helpful for other customers.

 

Thank you for your great work,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Learner1
Contributor III
Contributor III
Author

Hello, we are using QEM 6.6