1 Reply Latest reply: May 20, 2013 3:47 PM by Michael Dibble RSS

    Merging sheets together.

      Please help people.

       

      I have models:

      1. commands.qvw

      2. netstat.qvw

      3. analysis.qvw

       

       

      I want to merge these to one .qvw. So far i have created a new qvw with a sheet I have named 'HOME'. I have also added  3 sheets (tabs) namely: 'Commmands'; 'Netstat'; 'Analysis'. Each model consists of 1 sheet.

       

      On the HOME page I have created 3 buttons with the names of 3 tabs.

       

      I have managed to link the buttons on the HOME page to the sheets I have created but how do I link the models to the sheets to merge into 1 model?

       

      Where do i go from here? 

        • Re: Merging sheets together.

          You can only binary a single file in.  In your QVW load script, modify the script to save the exports as qvd files instead of a qvw.  Then in the secord file you can load the qvd files and merge them as needed.  Here is an example.

           

           

          In Source file

           

          Table_Name:

          SQL

           

               SELECT *

               FROM TABLE

           

          ;

          STORE Table_Name into C:\Data\Table_Name.qvd  (qvd);

          In Destination file

          Table_Name:

          LOAD *

          FROM C:\Data\table_Name.qvd;

          Table_Name1:

          LOAD *

          FROM C:\Data\table_Name2.qvd;

          Once the load is done, save the file as a qvw.  This will bring all of your data into a single file.