topic Re: Data loading as ? in App Development

Data loading as ?

Anonymous — Wed, 29 Nov 2017 12:25:04 GMT

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?

Re: Data loading as ?

1adam_haj — Wed, 29 Nov 2017 13:12:53 GMT

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

Re: Data loading as ?

Anonymous — Wed, 29 Nov 2017 14:23:52 GMT

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.

Re: Data loading as ?

1adam_haj — Fri, 08 Dec 2017 10:18:54 GMT

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