4 Replies Latest reply: Nov 25, 2012 10:01 AM by Anand Chouhan RSS

    Reload or Partial Reload

      I load one table

       

      Table1:

       

      load

       

      from source

       

      Now add second table

       

      Table2:

       

      load

       

      from source

       

      but i does not include it on reload activity i use partial reload but it not works does any one tell me about how to use it.

       

      Thanks

        • Re: Reload or Partial Reload
          Gysbert Wassenaar

          If your two source tables have the same fields and you don't specifically tell Qlikview to not concatenate the tables then all the records from both loads end up in Table1. This is usually the right thing to do. If you want to know which record came from which source add a field to store that information.

           

          Table1:

          Load *,

          'This record comes from Source1' as Source

          from source-1;

           

          Load *,

          'This record comes from Source2' as Source

          from source-2;


            • Re: Reload or Partial Reload

              Thanks, But sorry i am not properly explain my requirement it is like that

               

              I load a table say

               

              Table1:

              load

               

              Field1,

              Field2,

              Field3,

              ...

              From source;

               

              15 rows loaded in the reload

               

              Table2:

              load

              columnA,

              columnB,

              columnC,

              From source;

               

              25 rows loaded inthe reload

               

              But from 2 reload when i do reload i only want to reload the second table, i am not want to reload the Table1 because it is already loaded, I want to load only Table2.

               

              Thanks

              • Re: Reload or Partial Reload
                Anand Chouhan

                Hi,

                 

                Use some thing like

                Table1:

                load

                ..

                From Source;

                 

                Table2:

                 

                Add

                load

                ..

                From Source;

                 

                Put Add syntax above the load syntax of table for table that you want to load only like Table2 here

                And then from File Menu -> Partial Reload other wise use Ctrl + Shift + R

                 

                Regards,

                Anand