Trying to join two tables on more than one column

[danaleota]

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

Errors Table: 

Date

Site

Agent Id

Super Id

Error Type

Calls Table: 

Date

Site

Agent Id

Super Id

ANS

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

[anushree1]

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]

Please use autonumber not autogenerate sorry for the typo like

autonumber( Site&AgentId&SuperId) as Key,

[danaleota]

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 · Accepted solution]

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]

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