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

    Mapping

      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 !