topic Join Functionality Problem in QlikView

Join Functionality Problem

chandu441 — Thu, 21 May 2015 12:59:55 GMT

Here in the show script you can find two main tables Event and Intervals.

If I try to merge the both tables in the data model it is working succesfully. In data model we can see one resultant table

But while I'm trying to merge the both Resident tables it is not showing the resultant table

It is still showing two separate tables as Event , Intervals

//Join Prefix

Event:

LOAD EventID,

Date(Date#(EventDate,'YYYY-MM-DD'))as MyDate

FROM

(txt, utf8, embedded labels, delimiter is '\t', msq);

Intervals:

LOAD IntervalID,

Date(Date#(IntervalEnd,'YYYY-MM-DD'))as ToDate,

Date(Date#(IntervalBegin,'YYYY-MM-DD'))as FromDate

FROM

(txt, utf8, embedded labels, delimiter is '\t', msq);

//// ============ Merge two resident tables using a join ============

Temp:

Load

EventID,

MyDate

Resident Event;

Join

Load

IntervalID,

ToDate,

FromDate

Resident Intervals;

Plz solve my issue

Thanks Inadvance

rakesh_kumar — Thu, 21 May 2015 13:15:03 GMT

If you want to join you need to have an ID field on which you will be joining.

General Syntax:

Table1:

Load * from QVD1.qvd(QVD);

left join (Table1)

Load * from QVD2..qvd(QVD);

If you just want to concatenate make sure you have the field names same or at least 80% same for performance sake and use 'concatenate' key word.

maxgro — Wed, 01 Jul 2015 22:02:59 GMT

usually to join 2 tables you use at least 1 common field (common = same field name)

but in your question I guess you want to join using an interval match prefix

here the details