Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Within QV the graph shows how QV has loaded it - the highlighted sections should be NULL values, but it has duplicated the items.
No Joy ... tried a frsh app with clean SQL and still get the same issue ..
So it's SQL problem. I think you can try to change/reinstall the connction provider.
Or even try it on another mashine.
Thanks White .. Seems to be an underlying issue with the connector generated SQL .. back to dev with it
Well, tested the connector in SQL directly and it is working fine.. seems to be something QV is doing ..
any ideas anyone?
You can try it with another QV version (11, 10, 9).
Using V11 ..
dont have access to another one unfortunatley
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 ..