topic Re: MATCHING 2 TABLES Problem in QlikView

MATCHING 2 TABLES Problem

Thu, 11 Apr 2013 15:54:13 GMT

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!!!

Re: MATCHING 2 TABLES Problem

MarcoARaymundo — Thu, 11 Apr 2013 17:49:26 GMT

Try

Table A;

Right Join (Table A)

LOAD

FROM Table B;

Re: MATCHING 2 TABLES Problem

Thu, 11 Apr 2013 18:12:18 GMT

Hi ,

Please try the below code .

TABLEA:

ID ACD DATE

1 A 1/1/2013

2 B 10/1/2013

TABLEB:

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

NoConcatenate

TABLEC:

LOAD ID ,ACD , DATE

Resident TABLEA;

Left Join

IntervalMatch(DATE)

LOAD ACD, DATESTART, DATEEND, MODEL

Resident TABLEB;

DROP Table TABLEA,TABLEB;

If there is anything please let me know