Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi clever people.
I have the following scenario:
1) A table with customers with the date they visited our store:
Customer Number | Store Visit Date |
123 | 2022/01/20 09:06:49 |
123 | 2022/01/20 09:06:55 |
456 | 2022/01/20 14:01:22 |
2) A Table (for same customers), containing a Timestamp when this customer bought one of our products (at this time, we dont know per which visit...we only have the TIME a product was bought)
Customer Number | Product_bought_date | Product Bought |
123 | 2022/01/20 09:10:49 | Apples |
123 | 2022/01/20 09:12:55 | Bananas |
456 | 2022/01/20 15:03:22 | Meat |
Horrendous data - I know.
What I've been asked to do - The customer visits the store, and I need to know if he bought any products from us, within 1 hour of his visit.....(add 1 hour to the Store Visit date , and then see if the Product_bought_date is within that 1 hour bracket).
I dont want to join these two tables, as it will mess with the rest of my model, hence I was considering using applymap somehow - but I dont know how to put together this entire thing.
Much appreciated
Thank you so much - I will test it. Thanks for your trouble!
Thanks for your assistance!