NoOfRows Function

marco_puccetti — Mon, 25 May 2015 10:46:50 GMT

Hello, in an empty table, this function what number should return?

Another question is there any application cache that mantain old data previously loadede in data structure loaded by external configurationi file?

Thanks

Marco

Re: NoOfRows Function

CELAMBARASAN — Mon, 25 May 2015 10:56:58 GMT

If the table is empty, then it (NoOfRows) will give zero.

Application cache

You can explore the Partial Reload functionality, which serves your need. With Add or Replace prefix

Re: NoOfRows Function

marco_puccetti — Mon, 25 May 2015 11:02:55 GMT

Application cache

You can explore the Partial Reload functionality, which serves your need. With Add or Replace prefix

What's it? And how can i explore it?

Thanks

Marco

Re: NoOfRows Function

CELAMBARASAN — Mon, 25 May 2015 11:11:09 GMT

Refer the Help file.

To do a Partial reload--- File-->Partial Reload (Shortcut Ctrl+Shift+R)

About the ADD keyword from help file

The add prefix can be added to any Load, Select (SQL) or Map ... using statement in the script. It is only relevant during Partial Reload. During a partial reload the QlikView table, for which a table name is generated by the add load/add select statement (provided such a table exists), will be appended with the result of the add load/add select statement. No check for duplicates is performed. Therefore, a statement using the add prefix will normally include either a distinct qualifier or a where clause guarding duplicates. The map...using statement causes mapping to take place also during partial script execution.

The syntax is:

add [only] (loadstatement |selectstatement |mapstatement)

where:

only is an optional qualifier denoting that the statement should be disregarded during normal (non-partial) reloads.

Examples:

Tab1:

LOAD Name, Number FROM Persons.csv;

ADD LOAD Name, Number FROM newPersons.csv;

During normal reload, data is loaded from Persons.csv and stored in the QlikView table Tab1. Data from NewPersons.csv is then concatenated to the same QlikView table. See Concatenation.

During partial reload, data is loaded from NewPersons.csv and appended to the QlikView table Tab1. No check for duplicates is made.

Tab1:

SELECT Name, Number FROM Persons.csv;

ADD LOAD Name, Number FROM NewPersons.csv Where not exists(Name);

A check for duplicates is made by means of looking if Name exists in the previously loaded table data (see the function exists under exists(field [ , expression ] )).

During normal reload, data is loaded from Persons.csv and stored in the QlikView table Tab1. Data from NewPersons.csv is then concatenated to the same QlikView table.

During partial reload, data is loaded from NewPersons.csv which is appended to the QlikView table Tab1. A check for duplicates is made by means of seeing if Name exists in the previously loaded table data.

Tab1:

LOAD Name, Number FROM Persons.csv;

ADD ONLY LOAD Name, Number FROM NewPersons.csv Where not exists(Name);

During normal reload, data is loaded from Persons.csv and stored in the QlikView table Tab1. The statement loading NewPersons.csv is disregarded.

Re: NoOfRows Function

marco_puccetti — Mon, 25 May 2015 12:23:10 GMT

So, what does ADD statement do respect to the simple load with the exists statement?

Thanks

Marco

topic Re: NoOfRows Function in QlikView

NoOfRows Function

Re: NoOfRows Function

Re: NoOfRows Function

Re: NoOfRows Function

Re: NoOfRows Function