32 Replies Latest reply: Dec 17, 2012 12:34 AM by thomasschwartz RSS


      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 !