Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
FrederikV
Contributor
Contributor

Connection to SQL Server - How to prevent leading space removal

Hello,

We are using a SQL server. Some data contain leading spaces.

When I'm using the Microsoft SQL Server connector, or the ODBC connector, these leading spaces are removed. This is very annoying as we cannot distinguish data with leading spaces and data without leading space. For example, the article "  351634" and the article "351634" are considered as being the same article, which is not true.

I don't see any option to prevent this behavior, neither in the app nor in the QMC.

We also tried various drivers, without success.

What could we try?

Thanks in advance for your help

2 Replies
bdouden
Contributor
Contributor

Hi,

Check out this article: https://community.qlik.com/t5/Official-Support-Articles/Trailing-and-succeeding-blank-spaces-are-rem...

In the article only Qlik View is mentioned, but is works for Qlik Sense as well. Check both String values with the LEN-function.

Regards,

Boris

dennemanr
Contributor II
Contributor II

What I've resorted to when trying to solve problems like these is to add a character in the sql select statement like this:

 

sql select
    "A"+ItemFieldname as "ItemFieldName"
from db.table;