Problem with IntervalMatch

[#1]

Hello,

I'm using the IntervalMatch function to filter within a range of dates for a given date.

What I do is this:

QV_UNIDAD_PROGRAMA:

LOAD

COD_UP,

COD_TEC,

COD_SUBTEC,

PT_MAX,

FEC_INI_VIG as FIV_UP,

FEC_FIN_VIG as FFV_UP

FROM [$ (vpath) QV_UNIDAD_PROGRAMA.qvd] (qvd);

CalendarRes:

LOAD

AddedDate as Date,

Time (Frac (AddedTimeStamp), 'hh') & ': 00' as Time,

Num (Time (Frac (AddedTimeStamp), 'h') & '') + 1 as Period

RESIDENT TempCalendar;

Here the correct loads.

Union:

IntervalMatch (Date)

load distinct

FIV_UP,

FFV_UP

QV_UNIDAD_PROGRAMA resident;

But when we perform IntervalMatch, it generates the following:

And what I want to know is how Syn1 off the table?

Can anybody help me?

Thank you very much in advance.

A greeting.

[Aurelien_Martinez · Accepted solution]

Hi,

//After this

Union:

IntervalMatch (Date)

load distinct

FIV_UP,

FFV_UP

QV_UNIDAD_PROGRAMA resident;

//Use

Left join(QV_UNIDAD_PROGRAMA)

Load

*

residente Union

;

drop table Union;

[#3]

thanks so much, worked perfectly