join table

[paolojolly]

hi,

i'm new in qlik view and i have the following problem.

I have two table, one with document date and price

doc date	prize
01/02/2014	1
04/04/2014	2
15/05/2014	2,2
05/06/2014	2,5

and another with quotation date and quotation value

quotation   date	value quotation
01/01/2014	5
15/02/2014	6
03/03/2014	7
03/04/2014	8
05/05/2014	9

I need to join the two tables in order to obtain

doc date	prize	last value   quotation     with date <= doc date
01/02/2014	1	5
04/04/2014	2	8
15/05/2014	2,2	9
05/06/2014	2,5	9

can someone help me?

Thanks

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

tabPrice:
LOAD *
FROM [http://community.qlik.com/thread/143406] (html, codepage is 1252, embedded labels, table is @1);

tabValue:
LOAD *
FROM [http://community.qlik.com/thread/143406] (html, codepage is 1252, embedded labels, table is @2);

tabLink:
IntervalMatch ([doc date])
LOAD [quotation date],
    Alt(Previous([quotation date]),Today()) as [prev quotation date]
Resident tabValue
Order By [quotation date] desc;

hope this helps

regards

Marco

[paolojolly]

Thank you very much!

[MarcoWedel]

You're welcome

Regards

Marco