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: 
danaleota
Contributor II
Contributor II

Trying to join two tables on more than one column

I'm new to Qlik and trying to join two tables on more than one columns.  

Errors Table: 

DateSiteAgent IdSuper IdError Type

 

Calls Table: 

DateSiteAgent IdSuper IdANS

 

I'd like to join them on Site, AgentId, and SuperId.  Thanks!! 

1 Solution

Accepted Solutions
H_Julian
Contributor III
Contributor III

Since there seems to be only one different dimension on each table, just use the applymap function and match the missing dimension of table 2 to table 1

Greetings 

View solution in original post

5 Replies
anushree1
Specialist II
Specialist II

Please try:

Errors:
Load
autogenerate( Site&AgentId&SuperId) as Key,
Date as Error_Date,
Site as Error_Site,
[Agent Id] as [Error_Agent Id],
[Super Id] as [Error_Super Id]
Error Type
From <Path/Tablename>;

Join
Load
autogenerate( Site&AgentId&SuperId) as Key,
Date,
Site,
[Agent Id],
[Super Id],
ANS
From <Path/Tablename>;

anushree1
Specialist II
Specialist II

Please use autonumber not autogenerate sorry for the typo like

autonumber( Site&AgentId&SuperId) as Key,

danaleota
Contributor II
Contributor II
Author

Thank you I will try this when I get home.  Will this be different than a synthetic key or a composite key?  Thanks. 

H_Julian
Contributor III
Contributor III

Since there seems to be only one different dimension on each table, just use the applymap function and match the missing dimension of table 2 to table 1

Greetings 

Sue_Macaluso
Community Manager
Community Manager

Are you using QlikView or Sense? I would like to move this into the correct product forum. 

Sue Macaluso