Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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>;

Highlighted
Specialist II
Specialist II

Please use autonumber not autogenerate sorry for the typo like

autonumber( Site&AgentId&SuperId) as Key,

Highlighted
Contributor II
Contributor II

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

Highlighted
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

Highlighted
Community Manager
Community Manager

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

Sue Macaluso