Interval Match?Synethic key

[adamgaox]

Hi All,

Thanks in advance,

I want to generate two tables in QlikView with the relationship in following pictures,

what should I do in script?

[sujeetsingh]

Disintegrate the data in two tables and keep the Fields name common on which you want to join.

[sujeetsingh]

When there will be more that one key then there will be a sync key and hence there will be a sync table too

[sushil353]

Hi,

you can make a composite key in two table using your common fields and then use them to join..

[adamgaox]

Does the relationship have limitation to dataset?I can't understand how it works.Better put some scripts and data.Thanks.Su

[adamgaox]

Thanks Kumar,

it's a good way to solve the composite key,but I want to know how can I generate a relationship between that two tables,because we usually see a syn table generated by QlikView.The picture doesn't.

[sujeetsingh · Accepted solution]

The syn key and table is not visible as there are two modes of Table viewer data bodel

1- Internal Table Viewer

2- Source table viewer

What you are seeing in your pic is Source table viewer

[sujeetsingh]

See this sample for more details

[mjm]

Hello,

From my understanding you want to generate these two tables but have them linked by two fields identical in both tables.This will generate a synthetic key table.

With synthetic keys it is advisable to avoid these by renaming unnecessary linked fields. Synthetic keys can cause inaccurate data and bad performance in the applications. You should only have tables linked by one unique field.

Please mark this as answered and complete if this is helpful.

[marcus_malinow]

You could use a LEFT OUTER JOIN to join your interval match table on to your main data table, and then drop your interval match table.

Though it's worth pointing out that this is only appropriate where you are sure your data records only match to one interval, otherwise you'll end up duplicating data.