topic Re: Data sort and drop in QlikView LOAD in QlikView

Data sort and drop in QlikView LOAD

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Data sort and drop in QlikView LOAD

agni_gold — Thu, 22 Nov 2018 13:37:02 GMT

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

Re: Data sort and drop in QlikView LOAD

Anonymous — Thu, 22 Nov 2018 15:36:19 GMT

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.

Re: Data sort and drop in QlikView LOAD

agni_gold — Thu, 22 Nov 2018 17:01:44 GMT

can you share your qvd ?

Re: Data sort and drop in QlikView LOAD

Anonymous — Fri, 23 Nov 2018 01:33:22 GMT

Certainly, please refer to the attached.

Thank you.

Re: Data sort and drop in QlikView LOAD

Anonymous — Fri, 23 Nov 2018 01:37:42 GMT

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