topic Joining Tables in QlikView

Joining Tables

Anonymous — Mon, 06 Apr 2015 05:03:27 GMT

Hello,

I am trying to connect two tables, the problem is there are two column in First table which are Start time and End time, in Second table i have column which is Occurrence time. This two table must be connected with concatenation of Policy_Number and if occurrence date is between start and end time.

Policy_Number	Start_Time	End_Time
0001	1/1/2013	29/12/2013
0001	1/3/2012	1/9/2012
0002	5/6/2013	4/6/2014

Policy_Number	Occurrence_Time
0001	1/1/2013
0002	5/6/2013
0001	5/5/2012

Re: Joining Tables

pokassov — Mon, 06 Apr 2015 15:12:10 GMT

Hi!

t1:

load *

from

<your table2>;

Inner Join (t1) IntervalMatch (Occurence_Time,Policy_Number) LOAD Start_Time, End_time, Key

from

<your table1>;

Sergey

Re: Joining Tables

sunny_talwar — Mon, 06 Apr 2015 15:38:37 GMT

Table1:

LOAD Policy_Number,

Start_Time,

End_Time

FROM

[https://community.qlik.com/thread/158879]

(html, codepage is 1252, embedded labels, table is @1);

Table2:

LOAD Policy_Number,

Occurrence_Time

FROM

[https://community.qlik.com/thread/158879]

(html, codepage is 1252, embedded labels, table is @2);

Join (Table1)

IntervalMatch(Occurrence_Time, Policy_Number) LOAD Start_Time, End_Time, Policy_Number Resident Table1;

DROP Table Table2;

Output will look like this:

HTH

Best,

Sunny

Re: Joining Tables

Anonymous — Tue, 07 Apr 2015 01:30:29 GMT

Thank you sergey

Re: Joining Tables

Anonymous — Tue, 07 Apr 2015 03:06:45 GMT

Thank you sunny, what if i had more column in both table, because i only brought the column that in need to be connect in this question. for example, table one has name,id,date and so on but i dont want them to be used as key.