resident

[#1]

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,

[#2 · Accepted solution]

Hi Abdullah,

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

Eg

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