Data loading as ?

[Anonymous]

Hi All,

I am working on a project whereby my data is being loaded as a "?" instead of the data that is present in the database.

for example, my database has data like this:

AddressID	propertyname
270	Blah
271	blah 2
273
...	...
12548	more blahs

Whereas Qlik Sense is loading it as:

AddressID	propertyname
?	Blah
?	blah 2
?
...	...
?	more blahs

I cannot work out why the data is loading as it is, source data is coming from a SQL server (2012).

I have verified that the data is correct in the database and is correct in the QVD

This is happening on several tables especially where there is an ID field.

Any ideas experts?

[1adam_haj · Accepted solution]

So the "?" is being seen in the data table model preview ?
Sometimes this could be coused by some badly calculated column, try to load it as standalone column and check the data, if it will be still wrong i would look if there is something wrong with the connection in the data load script

[Anonymous]

Indeed it was.

It turned out, I neglected to set the linked field as a numeric from nvarchar.

changing the source data SQL to present the linked field as numeric has solved the issue.

[1adam_haj]

good i think that you could do the same in data load script with num() - alternative to your solution. But your solution worked as well