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

Multiple tables with only three fields in common

I am creating a QV document using tables from the US Census Bureau.  All the the tables have three fields in common (ID, ID2 and Geography).  I have a "Main Data" table and trying to connect it to the other tables.  However, with only those three fields in common it seems there are no other unique fields by which to associate them.  I have created one unique key (ID & '|' & ID2 & '|' & Geography as [%Key Field]), but that only links two tables together and leaves the others without a unique key by which to link them.  Any thoughts?

1 Solution

Accepted Solutions
Not applicable
Author

Actually I figured it out on my own.  I just needed to use a JOIN.

View solution in original post

2 Replies
Not applicable
Author

Actually I figured it out on my own.  I just needed to use a JOIN.

its_anandrjs

If Key is unique then make join between 2 tables based on Key.