topic How to join Resident tables by where clause in QlikView

How to join Resident tables by where clause

dijkstram — Tue, 12 Oct 2010 16:10:47 GMT

HI,

I'm not yet that familiar with Qlikview, I have searched the forum but didnot found the solution.

I want to load two Resident tables into one table dependent on a Where Clause. The Date of the first table is between the START DATE and END DATE of the second resident table. How to fix it. The Date column of the first table is not recognized. in the Where clause.

TabA:

LOAD

Key, Date

Resident A;

Inner Join(TabA)

LOAD

Key, STARTDATE, ENDDATE

Resident B

WHERE Date between STARTDATE AND ENDDATE;

Hope to hear soon from the experts.

Kind regards

How to join Resident tables by where clause

prieper — Tue, 12 Oct 2010 16:15:12 GMT

Have a look into the INTERVALMATCH()-function

HTH
Peter

How to join Resident tables by where clause

dijkstram — Tue, 12 Oct 2010 19:01:24 GMT

How to deal with the intervalmatch, from table A and the second table I have to load different columns, do you have an example

How to join Resident tables by where clause

prieper — Wed, 13 Oct 2010 13:18:07 GMT

Please find a sample in the attachment

HTH

How to join Resident tables by where clause

Wed, 13 Oct 2010 13:45:09 GMT

Hi,

When you joined tables "A" and "B", will be create a new table.

You need put your filter in the new table.

Ex.:

TableA:

...

TableB:

Inner Join (TableA)

....

NOCONCATENATE

(this is a new table whith data values from TableA and TableB)

TableA:

Load...

From...

Where Date >= STARTDATE

and Date <= ENDDATE;

How to join Resident tables by where clause

dijkstram — Fri, 15 Oct 2010 11:23:20 GMT

Thanks a lot, it was helpful