Join: combine 2 Tables If

[#1]

Hello,

i have 2 tables, offers and advertising. I want to combine 2 tables and add new field prom_id to the Offers table.
The condition for add the field prom_id is OfferDate > prom_date

My problem:
If the customer has received a promotion, then please enter the promotional code to the order if the order date is greater than Advertising Date.
I want to know which Advertising had the best response

Offers

cust_id	OfferId	OfferDate
1	o1	2010-07-01
1	o2	2011-09-11
2	o1	2009-06-02

Advertising

cust_id	prom_id	prom_date
1	a1	2010-06-20
1	a2	2010-07-02
1	a3	2011-08-01
1	a4	2011-08-25
2	a11	2010-09-11
2	a12	2011-01-08

I don't know how can i join the tables.
Do you know any other solution?

Thanks!!!

Sorry for my English

[deepakk · Accepted solution]

HI QlikJam,

I hope the attach application is what you are looking at helps.. Cheers..

[#3]

Hi, thank you.

I can work with the results.

Can you please explain me your script.

[deepakk]

hi,

I am joining the two tables based on the customer id.(in Qlikview if the field names are same then in automatically joins the field).

Since both the tables gets combined into one, it becomes easy for me to check the offerdate is greated than promo date.