Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

(qvd);

LEFT JOIN (TotTab)

LOAD USER,

     [Email In],

     [Email Out],

     [Total Email],

     Date

FROM

(qvd);

LEFT JOIN (TotTab)

LOAD USER,

     CallLength,

     hourstamp,

     CTS,

     [Call Time],

     [Caller ID],

     Destination,

     Talking,

      Date

FROM

(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?

1 Solution

Accepted Solutions
Not applicable
Author

What would I do in that case? Change the name of the field in the Phone table? USER is definitely the same in all three.

View solution in original post

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Best guess is that either your Date or USER field values are different in the Phone table. For example, perhaps the Date field in Phone is actually a timestamp?

-Rob

puttemans
Specialist
Specialist

Could you try to join only on one variable (User&'|'&Date) instead of 2 user and Date separately? Therefore, you rename USER and Date in each table so they won't link, and you add a new variable USER&'|'&Date as Link.


Regards,


Johan

Not applicable
Author

What would I do in that case? Change the name of the field in the Phone table? USER is definitely the same in all three.

puttemans
Specialist
Specialist

Indeed, as Rob mentions, if the content of the variable is different, it will never work either.

Not applicable
Author

Hate to mark myself as correct, but that did it. Thanks Rob and Johan!

JonnyPoole
Employee
Employee

There may be an issue joining on Date (or USER) from the phone table.  Consider aligning the data types by wrapping with Date() function :    Date(Date) as Date    ... and loading each individually to check the date values are being intepreted the way you expect so that they will join accordingly.

If the tables are at the same granularity , then a table concatenation with an extra field called 'TYPE' could offer some interesting possibilities.  One of the following 3 fields could each be added each of the loads to give the user a way to SLICE. It may also help with some set analysis.

'Email' as TYPE

'Confereance as TYPE,

'Phone' as TYPE,