topic Re: Appending Multiple Excel Files in one qvw in QlikView

Appending Multiple Excel Files in one qvw

Tue, 05 Mar 2013 15:55:07 GMT

Hi everyone,

I have data that I would like to upload into QV. The problem is that there are 2.5million rows and about 50 columns. I split the data into several XL files, but would like to join them all in QV. Please could anyone suggest a good way to achieve this?

Thank you

vcoder

Re: Appending Multiple Excel Files in one qvw

Tue, 05 Mar 2013 16:24:24 GMT

Well, I couldn't even load data from one file (700000+ rows and 50 cols). There was an error message about insufficient virtual memory. Can anyone shed some light on the XL upload limitations for QV?

Re: Appending Multiple Excel Files in one qvw

Chris_Rice — Tue, 05 Mar 2013 19:57:52 GMT

From the Reference Manual:

A Limitations and Requirements

A.1 Limitations of the Amount of Data to be Loaded

The amount of data that can be loaded into a QlikView document is very large. It is primarily limited by the

amount of primary memory of the computer. However, there is one inherent limitation in QlikView that you

must be aware of when building very large documents: A QlikView document cannot have more than

2,147,483,648 distinct values in one field.

The number of fields and tables as well as the number of table cells and table rows that can be loaded, is limited

only by RAM.

When running the 32-bit version of QlikView, RAM is limited to 2, 3 or 4 GB, depending on operating system

version and configuration, regardless of the size of physical memory in the computer.This limitation

does not exist when running the 64-bit version of QlikView.