Difficulty with joining table

[bwendos]

Hello,

I am new to Qlik and having difficulty in joining tables.  It goes like this :

• Unique identifier for a contract is Firm, Department, Category, Person. If key fields are not provided in the tables, refers to FDCP field which is a concatenation of the 4 elements above

But all those primary keys have duplicate data, do you have an idea of how I could join them?

I attached the data below 

Thank u in advance for your help

[JuanGerardo · Accepted solution]

Hi @bwendos, I think the best way is to generate this FDCP in your main table like this:

CONTRACT_BASIS:

LOAD

   *

   Firm & '|' & Department & '|' & Category & '|' & Person   AS FDCP

From [Lib:YourFolderonnection/CONTRACT_BASIS.csv];

In Qlik Sense tables are associated/joined by field names (recommended by only one field each), so creating this FDCP field in your main table will associate with other tables.

JG

[bwendos]

Thank you @JuanGerardo