Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Master III
Master III

like this

table1:

ClaimNoClaim

from.....


table2

ClaimNoPmt as  ClaimNoClaim

from...


it will link the two tables

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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;

Anonymous
Not applicable
Author

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".

Anonymous
Not applicable
Author

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