Discussion Board for collaboration on QlikView Scripting.
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
(txt, utf8, embedded labels, delimiter is '\t', msq);
//// ============ Merge two resident tables using a join ============
Plz solve my issue
If you want to join you need to have an ID field on which you will be joining.
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.
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