topic Re: loads in QlikView

loads

maniram23 — Mon, 11 May 2015 14:39:57 GMT

Hi experts,

what is limitation load ? what is the use ?

Re: loads

Mon, 11 May 2015 14:50:35 GMT

Hi Mani. The load sentence has not limitation, with this sentence you can 'load' the fields and values from your datasource. For example:

Stores:

LOAD

Name,

Direction,

Country

FROM

[..\STORE\Store.xlsx];

In this example, you are loading the fields: Name, Direction and Country from the datasource Store.xlsx

Also, you can load tables of MySQL database, SQL Server database, Oracle database, etc.

I hope that it helps!

Regards, Agustín

Re: loads

Bill_Britt — Mon, 11 May 2015 14:56:34 GMT

Are you referring to the Limited load in Debugger? If so it is used for test. If you have a script that pulls in large amounts of data and you make some changes, you can limit the number of records to load. This way you can test your script without having to reload the whole thing.

Bill