Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate load on nulls problem

Have an issue loading data and not sure how to resolve it.

My raw data set contains a set of values with NULL values in the data itself (sample attached)

When I load the data in using QV load script, it seems to duplicate values into the NULL cells on load when they are not there..

Data sample below..

data.jpg

Within QV the graph shows how QV has loaded it - the highlighted sections should be NULL values, but it has duplicated the items.

graph.jpg

16 Replies
Not applicable
Author

No Joy ... tried a frsh app with clean SQL and still get the same issue ..

whiteline
Master II
Master II

So it's SQL problem. I think you can try to change/reinstall the connction provider.

Or even try it on another mashine.

Not applicable
Author

Thanks White .. Seems to be an underlying issue with the connector generated SQL .. back to dev with it

Not applicable
Author

Well, tested the connector in SQL directly and it is working fine.. seems to be something QV is doing ..

any ideas anyone?

whiteline
Master II
Master II

You can try it with another QV version (11, 10, 9).

Not applicable
Author

Using V11 ..

dont have access to another one unfortunatley

Not applicable
Author

I tried

IF(ISNULL("Passing Aggregate")=-1, "Passing Aggregate",0 ) AS [Passing Aggregate],

to spot the nulls .. but it seems to populate every field with 0 as well ..