Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
draghici1109
Contributor III
Contributor III

inner join intervalmatch produces an empty table

Greeting to the community!

Following Code produces an empty table and I do not have any clue why this is happening!

 

BGRAD:
LOAD Distinct
// num#(PERNR) AS PERNR,
PERNR,
BSGRD,
Num(BEGDA) AS BStart,
Num(ENDDA) AS BEnd
FROM [..\DATA\00-08000000-90-100-PA0008.qvd](qvd);
Store [BGRAD] into [..\DATA\BGRAD.qvd](qvd); //25062 Records read


inner Join IntervalMatch (DATUM_SAP, PERNR)
LOAD distinct
BStart,
BEnd,
// num#(PERNR) AS PERNR
PERNR
Resident BGRAD;
Store [BGRAD] into [..\DATA\BGRAD1.qvd](qvd); // 0 records read

The results look like this (log file):

CAL-1 << 00-08000000-90-100-T528T (row-based qvd optimized) 8.752 Lines fetched
HRP1001 << 00-08000000-90-100-HRP1001 8.569 Lines fetched
HRP1001 311.680 Lines fetched
BASE << HRP1001 311.680 Lines fetched

...

BGRAD << 00-08000000-90-100-PA0008 25.063 Lines fetched
BGRAD-3 << BGRAD 0 Lines fetched

==================

DATUM_SAP is produced as follow:

For y=Year(Today()) to (Year(Today())+5)
For m=1 to 12

CAL:
LOAD
MakeDate($(y),$(m),1) AS DATUM_REAL,
Num(MakeDate($(y),$(m),1)) AS DATUM_SAP
AutoGenerate(1);
Next
Next

Left Join
LOAD Distinct
PLANS
FROM [..\DATA\00-08000000-90-100-T528T.qvd](qvd);

HRP1001:
LOAD
RSIGN,
RELAT,
BEGDA,
ENDDA,
SUBTY,
SCLAS,
SOBID,
PROZT,
Num(BEGDA) AS Start,
Num(ENDDA) AS End,
OBJID AS PLANS,
OBJID
FROM [..\DATA\00-08000000-90-100-HRP1001.qvd](qvd)
WHERE PLVAR = $(vPLVAR) and OTYPE='S';

Inner Join IntervalMatch (DATUM_SAP, PLANS)

// matchfield:DATUM_SAP contains the discrete numeric value to be linked to intervals
// keyfield: contains attribute that are to be matched in the transformation
LOAD Distinct
Start,
End,
PLANS
Resident HRP1001;

DROP Table CAL;

Alexandru Draghici
BICC at Komm.ONE
Labels (2)
0 Replies