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
