topic Re: Interval Match?Synethic key in QlikView

Interval Match?Synethic key

adamgaox — Fri, 14 Nov 2014 08:57:22 GMT

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?

Re: Interval Match?Synethic key

sujeetsingh — Fri, 14 Nov 2014 08:59:43 GMT

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

Re: Interval Match?Synethic key

sujeetsingh — Fri, 14 Nov 2014 09:00:31 GMT

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

Re: Interval Match?Synethic key

sushil353 — Fri, 14 Nov 2014 09:03:56 GMT

Hi,

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

Re: Interval Match?Synethic key

adamgaox — Fri, 14 Nov 2014 09:05:42 GMT

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

Re: Interval Match?Synethic key

adamgaox — Fri, 14 Nov 2014 09:09:37 GMT

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.

Re: Interval Match?Synethic key

sujeetsingh — Fri, 14 Nov 2014 09:16:57 GMT

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

Re: Interval Match?Synethic key

sujeetsingh — Fri, 14 Nov 2014 09:17:23 GMT

See this sample for more details

Re: Interval Match?Synethic key

mjm — Fri, 14 Nov 2014 09:38:15 GMT

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.

Re: Interval Match?Synethic key

marcus_malinow — Fri, 14 Nov 2014 09:47:41 GMT

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.

Re: Interval Match?Synethic key

adamgaox — Sat, 15 Nov 2014 08:50:34 GMT

Thanks a lot. Su

I've tried to use table view -Source Table Viewer Mode

It's what I want to see.

It's an interesting function.