Discussion board where members can get started with Qlik Sense.
I'm new to Qlik and trying to join two tables on more than one columns.
I'd like to join them on Site, AgentId, and SuperId. Thanks!!
Go to 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
Errors:Loadautogenerate( 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 TypeFrom <Path/Tablename>;
JoinLoadautogenerate( Site&AgentId&SuperId) as Key,Date,Site,[Agent Id],[Super Id],ANSFrom <Path/Tablename>;
Please use autonumber not autogenerate sorry for the typo like
autonumber( Site&AgentId&SuperId) as Key,
Thank you I will try this when I get home. Will this be different than a synthetic key or a composite key? Thanks.
Are you using QlikView or Sense? I would like to move this into the correct product forum.