topic Re: Join Tables! HELP in QlikView

Join Tables! HELP

farolito20 — Mon, 14 Jan 2013 15:46:11 GMT

I need to join both tables:

Table1:

codCosecha,

Start,

End,

Group1

Table2:

Date,

Group2

The condition to join: (Group1=Group2) and (Date between Start and End)

Table3:

Date,

Group2,

codCosecha

Help!

Mon, 14 Jan 2013 16:14:22 GMT

Hi,

QV uses natural joins: attributes with same name are joined, others not:

NullAsValue Start, End, Date;

load

Date,

Group2 as Group

resident Table2

inner join intervalmatch(Date, Group)

load

Start,

End,

Group1 as Group,

codCosecha,

resident Table1;

Greets

Klaus