6 Replies Latest reply: Dec 15, 2015 9:40 AM by Jonathan Poole RSS

    JOIN multiple QVD's

      I have daily data on phone, email, and conference data in three separate QVD's. They have two common fields, USER and DATE.

       

      From what I read, I could create one table joining all three with:

      TotTab:

      LOAD Date,

           [CONF.Start Time],

           USER,

           CONF.Duration,

           CONF.Notes,

           CONF.StartTime

      FROM

      [R:\Daily Call Counts\Nov15CSRCONF.qvd] (qvd);

       

       

      LEFT JOIN (TotTab)

      LOAD USER,

           [Email In],

           [Email Out],

           [Total Email],

           Date

      FROM

      [R:\Daily Call Counts\Nov15CSRMail.qvd] (qvd);

       

       

      LEFT JOIN (TotTab)

      LOAD USER,

           CallLength,

           hourstamp,

           CTS,

           [Call Time],

           [Caller ID],

           Destination,

           Talking,

            Date

      FROM

      [R:\Daily Call Counts\Nov15CSRPhone.qvd] (qvd);

       

      This loads without an error message; however, there is only data from the Conf and Mail tables. No data at all from the Phone table.

       

      What am I doing incorrectly?