5 Replies Latest reply: May 25, 2011 6:10 AM by Kaushik Solanki RSS

    regarding data reloading

    Sushil Kumar

      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

        • regarding data reloading

          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.

            • regarding data reloading
              Sushil Kumar

              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

                • regarding data reloading
                  s j

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

                   

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

                  • regarding data reloading

                    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

                      • Re: regarding data reloading
                        Kaushik Solanki

                        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