Join by dates

ester_pr — Tue, 26 Jul 2011 13:39:48 GMT

Hi,

I want to join tables

on table have costNamber, cost and date_of_updatd

and the oter have costNamber and date_of_debit,

of cuorse the cost shuold be attached to the cost of the date that in between the date_of_updatdes

how to do it when ther is one field of date?

is it better to do so in a script or in the object?

Thank you,

Ester

rohit214 — Tue, 30 Aug 2011 12:30:12 GMT

tab1:

load

costNamber as costNamber_tab1,

cost ,

date((date_of_updatd),'DD/MM/YYYY') as common_date

;

tab2:

load

costNamber as costNamber_tab2,

date( date_of_debit),'DD/MM/YYYY) as common_date

;

i hope u understand .

Thanx and Regard

rohit

topic Join by dates in QlikView