Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

MATCHING 2 TABLES Problem

Hi to All!!

I have a problem

I have 2 tables and i have to join those tables but, as follow:

TABLE A

ID       ACD         DATE

1           A            1/1/2013

2           B          10/1/2013

TABLE B

ACD          DATESTART       DATEEND       MODEL

A               1/12/2012          31/12/2012          A1

A               1/1/2013            31/12/2013          A2

B               1/1/2013            31/12/2013          B1

B               1/1/2014            31/12/2014          B2

RESULT of JOIN

TABLE C

ID          ACD          MODEL

1               A               A2

2               B               B1

As you can see, the join is based on ACD as Key, and the comparison of DATE from TABLE A against DATESTART and DATEEND from TABLE B

How can i perform this???

Thanks!!!

1 Reply
Not applicable

Re: MATCHING 2 TABLES Problem