12 Replies Latest reply: Jun 3, 2014 12:26 PM by Erik Anderson RSS

    Loading multiple qvd files into one table

    Matt Maino

      In my data model I am taking several qvd files created in my extract, and loading them into the same table. For some reason qlikview is creating a separate table for each qvd rather than just concatenating them onto each other. Is there a keyword that I can use in the code shown to prevent qlikview from creating multiple tables for each qvd? Thanks.

       

      Table1:

      LOAD

      Field1,

      Field2,

      Field3

      FROM

      Table1\Table1_*.qvd(qvd);

       

       

      Table2:

      Inner Keep (Table1)

      LOAD

      Field1,

      Field4,

      Field5

      FROM

      Table2\Table2_*.qvd(qvd);