Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
trishita
Contributor III

Synthetic keys

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?

1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

Re: Synthetic keys

Hi,

this looks like a double post?

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

View solution in original post

2 Replies
datanibbler
Esteemed Contributor

Re: Synthetic keys

Hi,

this looks like a double post?

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

View solution in original post

trishita
Contributor III

Re: Synthetic keys

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);