Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.
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