Synthetic keys

[trishita]

I have joined two tables based on intervalmatch function

General Information:

LOAD *
FROM
[MO_BUN_SUR_SURVEY_VIEW.qvd]
(qvd);

Sounding Correction:

LOAD *

FROM
[mo_purch_sounding_correction_view.qvd]
(qvd);

Inner Join

INTERVALMATCH (SURVEY_DATE,IMO_NO) SELECT SOUNDING_START_DATE,SOUNDING_END_DATE,IMO_NO

resident Sounding Correction;

The table is joined but I have one issue:I have one problem that there are 2 synthetic keys created .In 1 table which contains only IMO No and Survey ID and the other synthetic key table which contains all other fields.As I am new to Qlikview is it advisable to drop the other synthetic keys which are not the main keys?

[datanibbler · Accepted solution]

Hi,

this looks like a double post?

Anyway - if they are not necessary for linking the tables, drop the synthetic keys.

[trishita]

I solved this problem using qualifiers:

  Qualify *;

Unqualify SOUNDING_START_DATE,SOUNDING_END_DATE,IMO_NO;


SoundingCorrections:

LOAD *

FROM
[mo_purch_sounding_correction_view.qvd]
(qvd);