Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vardhancse
Valued Contributor II

Calculated Primary Key

Hi,

I want to create one calculated primary key, but requirement is that:

Primary key in Table 1, but the condition is lookup from Table 2 and some field conditions from Table 3.

Here there is no join between table 1 and Table 2 but we need to do lookup.

2 Replies
marcus_malinow
Valued Contributor III

Re: Calculated Primary Key

Hi Sasi,

it might help if you provided a few lines of data from each table to help illustrate the issue.

It sounds like you'll need to maybe do something like:

Load Table 2

Load Table 3

Set up mapping table based on Table 3

Load Table 1 where your key exists in Table 2, and also maybe where the results of the Table 3 mapping are ok

Marcus

sbobbyraj
Contributor III

Re: Calculated Primary Key

Hi,

Please give an exemple.

I think you sould make a left join between table 1 et 2 to get only the needed field into table 1 (not all field from table 2 but only needed ones) then the same process with table 1 and 3.

Community Browser