Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jadewind
Contributor

Creating key/association after loading data

Hi everyone,

I have loaded three data sets in QS. I have renamed some fields so that when loading there won't be keys joining the tables. Now if I want to manually join the tables, how can I select the keys I want to link? Eg. I want to link two tables using "ClaimNoClaim" and "ClaimNoPmt" from the two tables.

Thanks in advance for any help!

4 Replies
arulsettu
Honored Contributor III

Re: Creating key/association after loading data

like this

table1:

ClaimNoClaim

from.....


table2

ClaimNoPmt as  ClaimNoClaim

from...


it will link the two tables

phaneendra_kunc
Valued Contributor III

Re: Creating key/association after loading data

Once data is loaded only way i guess is to go to Editscript and edit the autogenerated section script.

If both fields exists in both tables.

Table1:

"ClaimNoClaim" & "ClaimNoPmt" as Key,

....,

from xyz;


Table2:

"ClaimNoClaim" & "ClaimNoPmt" as Key,

....,

from ABC;

h_eskelinen
New Contributor III

Re: Creating key/association after loading data

Hey there,

The only way to link the tables is to edit the load script. The simplest way to accomplish this is to rename either of the fields in one of the tables so that the names match, i.e. rename "ClaimNoClaim" as "ClaimNoPmt" or vice versa. The alternative is to rename both fields, giving them a new name such as "Key".

jadewind
Contributor

Re: Creating key/association after loading data

Thanks everyone. Looks like there are no alternatives but to make the names the same...

Community Browser