Hello there !
I have 2 tables, one with my visit logs on my site and structured as:
Table 1:
Visit date | visitor ID | Order ID | Visit source | Visit number
One with my sales data as:
Table 2:
Order ID | Customer ID | Sales amounts
I haven't been able to properly link Customer ID (table 2) and visitor ID (table 1) to be able to see:
Customer ID | visitor ID | Visit source | Visit number | Sales amount
Can anybody help me with that, I've spent hours on this. There might be something to be done with applymap but haven't been successful yet...
Thanks in advance !
