Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
dana8315
New 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
New Contributor II

Re: Trying to join two tables on more than one column

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 

5 Replies
anushree1
Valued Contributor

Re: Trying to join two tables on more than one column

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
Valued Contributor

Re: Trying to join two tables on more than one column

Please use autonumber not autogenerate sorry for the typo like

autonumber( Site&AgentId&SuperId) as Key,

dana8315
New Contributor II

Re: Trying to join two tables on more than one column

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
New Contributor II

Re: Trying to join two tables on more than one column

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 

Community Manager
Community Manager

Re: Trying to join two tables on more than one column

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

Sue Macaluso