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:
Left Keep (Table 1)
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.