Qlik Partial QVD load

[AnkitMadhukar]

Hi Everyone,

I have an app that loads data from an QVD. In the recent loads the data load was successful but when I checked the number of records , I noticed that few records were not loaded even though they were there in the QVD. I did not get any error as well while data load.

On reloading the same QVD , I got the records previously left out (no changes in the script as well)
Not sure what's causing the issue here.
Anyone faced similar issues.

Thanks 
AM

[Tanalex]

What was the script you were using to pull data?  No reason all rows, from a QVD, should not be pulled, unless there was some criteria that limits what was being selected/joined/etc.

[AnkitMadhukar]

Hi @Tanalex ,
Its just a simple load statement , single table in the whole app. That's what makes it slightly weird.

[Ksrinivasan]

hi,

if the master QVD schedule may not completed,

refresh issue,

i hope you got full data after refresh only,

ksrinivasan.

[Tanalex]

Is the load script something you could share?  Is it an INLINE load, or pulling from a file? 

[AnkitMadhukar]

Its just a simple load statement loading from QVD

LOAD
X,
y,
Z
FROM [lib://QVDName.qvd]
(qvd);

[Tanalex]

Based on the script, I see no reason why rows would be missing.  If this is an incremental load, it is possible that data has changed/was deleted between incremental loads, thus the missing records.

[elizabeth__]

Hello,

Could it be related to multiple identical rows? You could add an automatically generated row number to make sure all rows are viewed as being distinct. E.g.

LOAD
RecNo(),
X,
y,
Z
FROM [lib://QVDName.qvd]
(qvd);

You may need to compare the record numbers being written to the QVD versus being read from the QVD.

- Elizabeth