topic Re: Difficulty with joining table in Connectivity & Data Prep

Difficulty with joining table

bwendos — Sun, 02 May 2021 13:58:59 GMT

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

Re: Difficulty with joining table

JuanGerardo — Sun, 02 May 2021 18:20:18 GMT

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.

Re: Difficulty with joining table

bwendos — Sun, 02 May 2021 21:31:14 GMT

Thank you @JuanGerardo