topic Re: resident load with examples? in QlikView

resident load with examples?

Fri, 07 Feb 2014 17:54:34 GMT

resident load with examples?

Re: resident load with examples?

swuehl — Fri, 07 Feb 2014 17:59:40 GMT

http://community.qlik.com/thread/105549

Re: resident load with examples?

Fri, 07 Feb 2014 18:10:47 GMT

Resident is word means from RAM. Suppose if we get the table from source example SalesRep.we saved locally in qlikview with name SalesRep.then we want to use it again then instead connecting source and getting the fields we use resident load like below.

for example:

Resident Load:

Temp:

LOAD

FROM Data;

Temp1:

LOAD

FROM Temp;

Temp2:

LOAD

FROM Temp;

regards

Mahesh T.

Re: resident load with examples?

Fri, 07 Feb 2014 18:14:12 GMT

Resident load and precedding load

check the above link will be helpful to you.

regards

Mahesh T

Re: resident load with examples?

maxgro — Fri, 07 Feb 2014 18:27:48 GMT

resident pag. 14 and a lot of other load

LOAD data into QlikView

Re: resident load with examples?

chiru_thota — Fri, 07 Feb 2014 18:54:52 GMT

Syntax:
load [ distinct ] *fieldlist

[( from file [ format-spec ] |

from_fieldfield [format-spec]

resident table-label )]

[ where criterion ] | while criterion ]

[ group_by fieldlist ]

[order_by field [ sortorder ] { , field [ sortorder ] } ]

If you are not able to follow the syntax try the example below,

Example:

The resident table is useful when we want to split a table into multiple cubes, say for example when we want to create table X with specific year using the main table A and create another table Y with specific division/department using the same main table A it is possible using RESIDENT Table concept.

Table: A
Division	Department	Year
1	A	2010
2	B	2011
3	C	2010
4	D	2012
5	E	2010

X:
Load * from A Where year=2010;

Output:

Table: X
Division	Department	Year
1	A	2010
3	C	2010
5	E	2010

Y:
Load * from A Where Div in ('1','3');

Output:

Table: Y
Division	Department	Year
1	A	2010
3	C	2010

Re: resident load with examples?

Christian_Lauritzen — Fri, 07 Feb 2014 19:22:00 GMT

Here is an example on resident load, i.e. you load from an already loaded table. Below we first create the table Countries. Here Inline is used, but it might as well have been loaded from a database or spreadsheet. In the second statement the RESIDENT syntax is used to load values from the Countries table to create a new field for countries larger than 500 000 km2. The tables are joined. Hope this helps you on the way.

Countries:

LOAD * INLINE [

Country, Area

France, 547030

Spain, 505782

Sweden, 449964

Norway, 385252 ];

Join(Countries) Load

Country,

Area,

'>500 000' as Category

Resident Countries

Where Area>500000;

Result:

Re: resident load with examples?

Sat, 08 Feb 2014 04:38:37 GMT

Hi Manoj,

can you please close the thread if you are fine with answers posted so that it will be helpful to other users as well.

regards

Mahesh T

Re: resident load with examples?

MK_QSL — Sat, 08 Feb 2014 07:24:39 GMT

Let me also try...

Temp:

Load * Inline

[

Customer, Sales

A, 100

B, 200

A, 300

C, 150

D, 200

B, 140

E, 400

C, 340

];

//The above table is showing only two columns but it should have some dates, months or years but it is not necessary //for this example, so I haven't mentioned.

Final:

Load

Customer,

SUM(Sales) as [Total Sales]

Resident Temp

Group By Customer;

Drop Table Temp;

//The 2nd table is calculating Total Sales per customer using Resident Load of First Table.

//We don't need Temp table, so we can remove it now.

Hope this help.