topic Re: generate fact table using already loaded tables not from any source file or database in QlikView

generate fact table using already loaded tables not from any source file or database

agni_gold — Sat, 09 Nov 2013 13:58:25 GMT

I need a help regarding Qlikview scripting.

i have multiple tables and i have already loaded these table in qlikview .

Now i want to make a fact table using these loaded tables not from any source file .

Can it be possible ?

If yes then please tell me how , please provide some sample code to understand.

Thanks.

Best Regards ,

Agnivesh Kumar

Re: generate fact table using already loaded tables not from any source file or database

swuehl — Sat, 09 Nov 2013 14:20:18 GMT

You can do a resident table load, i.e. state a table already loaded to your data model as data source:

// Initial load from data source

TABLEA:

LOAD

FIELDA,

FIELDB

FROM YourDBTable;

//Resident Load field A

LOAD FIELDA RESIDENT TABLEA;

Re: generate fact table using already loaded tables not from any source file or database

Sat, 09 Nov 2013 14:21:26 GMT

Hi,

Use the RESIDENT keyword.

Instead of having

LOAD .... FROM Afile (as you have already done)

you do

LOAD .... RESIDENT QVTable

where QVTable is a QlikView table already loaded. The syntax is the same as a file.

So first you load the files, after that you "transfert" the data from these tables to the definitve table.

If you want to load your fact table from different QV tables, you will need to load the first table, use JOIN (LEFT, RIGHT, INNER, OUTER) for the following tables.

You can also drop the temp tables at the end of the process.

Fabrice