Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI QlikJam,
I hope the attach application is what you are looking at helps.. Cheers..
HI QlikJam,
I hope the attach application is what you are looking at helps.. Cheers..
Hi, thank you.
I can work with the results.
Can you please explain me your script.
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.