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