Creating key/association after loading data

[Anonymous]

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!

[arulsettu]

like this

table1:

ClaimNoClaim

from.....

table2

ClaimNoPmt as  ClaimNoClaim

from...

it will link the two tables

[phaneendra_kunc]

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]

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]

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