topic Re: Load x rows from all tables in QlikView

Load x rows from all tables

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

Hello,

¿Is there any way to make the in the script to load the first 100 rows from all the tables?

thank you

Re: Load x rows from all tables

Anonymous — Tue, 18 Apr 2017 08:25:52 GMT

Maybe you should be using RecNo ‒ QlikView and limit the values

Re: Load x rows from all tables

ngreddy1982 — Tue, 18 Apr 2017 09:00:46 GMT

Hi,

you can use select statement like select top 100 or load statement

table:

First 100 Load

From table.csv;

Re: Load x rows from all tables

Colin-Albert — Tue, 18 Apr 2017 09:46:07 GMT

If you enable debug-mode you can set a row limit of 100 which applies to all tables.

To access debug mode select "Debug" from the script editor File Menu

Re: Load x rows from all tables

Anonymous — Tue, 18 Apr 2017 10:21:51 GMT

i was looking instead of the debugger to write 'something' on the script.

Re: Load x rows from all tables

vinieme12 — Tue, 18 Apr 2017 12:09:11 GMT

Use First statement, see help on how to

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/First.htm

Re: Load x rows from all tables

Colin-Albert — Thu, 27 Apr 2017 10:30:02 GMT

In the script you can use the FIRST N prefix before the load where N is an integer, but the first limit only applies to the next table being loaded, so you would have to add FIRST before each table.

Table1:

First 1000

load ... from ... ;

Table2:

First 500

load ... from ...;

Using the Limit in Debug mode applies the limit to ALL tables in the script.

Re: Load x rows from all tables

maxgro — Thu, 27 Apr 2017 11:12:13 GMT

first ..... in a variable

SET vFirst = First 100; // for test

//SET vFirst = ;

$(vFirst)

load 1 as f1

autogenerate 1000;

$(vFirst)

load 1 as f2

autogenerate 1000;

Re: Load x rows from all tables

Peter_Cammaert — Thu, 27 Apr 2017 11:51:09 GMT

And as an extension of Massimo's technique, consider creating a document variable vDebug that enables all debug and testing measures. You can then do something like this:

IF len(trim(vDebug)) > 0 THEN

SET vFirst = FIRST 100;

SET vDebug = 1;

END IF

Table:

$(vFirst)

LOAD 1 AS F1

AUTOGENERATE 1000;

IF vDebug = 1 THEN

STORE Table INTO [.\Table.qvd] (qvd); // For inspection

END IF

LET vFirst=;

EXIT Script;

or define a variable with parameters to embed or disable a dynamic STORE of every table you want to inspect.

Best,

Peter