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

[agni_gold]

Hi

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

[swuehl]

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;

[#3]

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