Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I faced one Issue.
I am extracting one table from SQL Server Database. I have created QVD.
Actually in my SQL table having 1000 records, but when i am extracting QVD it showing 900 records only.
What was the problem??
Thanks in Advance.......
Without looking your database or your sql query, difficult to answer... it would be helpful if you can share something more ...
Hi Manish,
Present i don't have data.
Any idea of this type of issue's
Hi Paul,
Is it possible that there are duplicate rows ?
You could create your own unique key using rowno(), for example:
rowno() as row_id
Thanks
Mark
Hi Paul,
please reload ur qvd once and check again because in databases date ll add in time bases ... please check it this might be one of the reason
or else u have check from witch record it is not showing the date .... in qvd that u have to compare in the database
Hi,
Go through this blog-post.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno
Regards
ASHFAQ
How are you checking that your qvd is having 900 records? Using Count() function or something else.
If the database is a hot replica, check if your qvd is updated with latest data or not.
Check the Script Execution Trace when you reload the application and see how many rows are pulled from qvd.
Thanks,
Singh