3 Replies Latest reply: May 28, 2014 2:55 PM by Michael Solomovich RSS

    Qlikview creates new table for each qvd file.

    Matt Maino

      I am in the process of using an extract and data model solution in qlikview to create reports for a department in my organization. I have an extract that takes each table from a database and puts them in designated folders as qvd files. I have it set so that it creates a new qvd everyday for each table. I then retrieve these qvd files in my data model script and make connections between them. An example of this is show below:


      Table1:

      LOAD

      *

      FROM

      Table1\Table1_*.qvd(qvd);

       

      Table2:

      Left Keep (Table 1)

      LOAD

      *

      FROM

      Table2\Table2_*.qvd(qvd);

       

      I have an issue where when I load more than one qvd for each table it will create a separate version of the table called Table1-2 or Table1-3 (depending on how many qvd files I import). Is there an easy way that I can fix this code to concatenate the data from these multiple qvd files onto the table they are associated with? Thank you.