Data sort and drop in QlikView LOAD

[Anonymous]

Hi Guys,

I need some assistance please. I am extracting data from a SQL Table and storing into a QVD file. I then load the 117720 rows from the  stored QVD but if a copy the stored QVD file to another machine and load the QVD file with another QlikView instance (Same Version) or Qlik Sense Cloud it only loads 117683 rows and some fields are missing.

Any ideas why this is occuring?

Thank you.

Regards

Craig 

[agni_gold]

I believe in your data there would be some kind of characters which can not be loaded in qliksense /qlikview, you can find what record is not loaded, can check your data.

Thanks

[Anonymous]

Thank you for your response and assistance. This was also my thought but what puzzles me is that it loads correctly with one instance of QlikView but not with another once I have copied the file to another server. Surely, if there were unloadable characters then it would not load correctly in either.

[agni_gold]

can you share your qvd ?

[Anonymous]

Certainly, please refer to the attached.

Thank you.

[Anonymous]

When I load the QVD from the originating QlikView instance, I get 117823 rows but once I have copied to the other instance and I load, Qlikview only loads 117683 rows.

Thanks