topic AW:Re: Join: combine 2 Tables If in QlikView

Join: combine 2 Tables If

Wed, 23 Feb 2011 10:35:57 GMT

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

Join: combine 2 Tables If

deepakk — Wed, 23 Feb 2011 11:31:00 GMT

HI QlikJam,

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

AW:Re: Join: combine 2 Tables If

Wed, 23 Feb 2011 12:01:41 GMT

Hi, thank you.

I can work with the results.

Can you please explain me your script.

AW:Re: Join: combine 2 Tables If

deepakk — Wed, 23 Feb 2011 12:18:33 GMT

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.