Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master II

regarding data reloading

Hi experts,

suppose i have five tables to load in the application. Among the five table there is one table on which i want to aply incremental load..

Now i want such technique so that the rest four tables must be loaded for the first time load.. when i try to aply the incremental load on fifth table the rest four table should not load again and again...

How can i solve the above said problem..

Thanks in advance

5 Replies
Not applicable

Hi,

Create a script just for loading those four tables and store the resulting data in qvd files. Then, in another qvw document, load qvd data and create a query for updating only the fifth table.

sushil353
Master II
Master II
Author

Hi Medina,

How could we store the four table in qvd file as qvd file can only store single table..

And how can i used two or multiple qvd file in single application.

Thanks

suniljain
Master
Master

you can store single QVD of four different table by performing join operation.

you can use multiple QVD in single application by linking QVD.

Not applicable

Hi,

First create a qvw file, which will only read the four tables from database and store each one in a different qvd file.

Then, in another qvw file you have to read those qvd files in the way:

Load A,

     B,

     C,

     ....

file1.qvd

(qvd);

Load A,

     B,

     C,

     ....

file2.qvd

(qvd);

and so on.

You can use the wizard for importing qvd files

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Create a varibale named "v". From Settings->Variable. set value 0.

    Copy below Script to your script.

if $(v) = 0 then
LOAD * INLINE [
    Data, Min, Max
    A, 0, 10
    B, 1, 20
    C, 2, 30
    D, 3, 40
];
ELSE
LOAD * INLINE [
    Data1, Min1, Max1
    A, 0, 10
    B, 1, 20
    C, 2, 30
    D, 3, 40
];

let v = 1;
end if

Also have a look at the attachment.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!