resident

Mon, 19 Apr 2010 10:02:28 GMT

dears,

i want some one here to explain for what

1- resident

2- where cluse

3- and group by

and example of using it

regards

A bDullahk,

Mon, 19 Apr 2010 10:12:17 GMT

Hi Abdullah,

1. Resident --> to load the data from the previous loaded table

Table 1:

Load a,b,c from xyz.xls

Table 2:

Load a,b,c,b+c as d resident Table1;

2. Where Clause --> is to filter the data during loading

Eg:

Load a,b,c from xyz.xls where a=1; --> it's load only those records where a has value as "1"

3. Group By --> basically used during summation or categorizing the data

Eg:

Load a, b, Sum(c) resident Table1 group by a,b;

Regards

Rajesh

topic resident in QlikView