Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Why using Mapping....
Just forget mapping here
They aren't the same...
Right now, this is what happens, the link only happens when the visit lead to a Purchase:
Try joining with only Visitor iD
and rename OrderID too to a diffrent allias name
Place a sample and explain the linking issues in dashboard with textbox,,,
Alright, I found a solution:
First load the sales table
Then load only visitor ID and Order ID from table 2
Then load only visitor ID and the rest of the visit data from table 2
I do "normal" loads (no code added) but my computer seems to have
difficulties coping. Is there a better load method, CPU-wise ?
is your visitor id and customer id same...???
because in mapping the first condition is to add the common field and after that which fields you want i.e sales amount according to your request
if you will tried to write visitor id as customer id .then it works
No, they're not. My only common field is order ID
Actually it seeems i am not able to catch your need.
What about using orderid to join both table.
even try to use concatenate..
Plz give sample .
istly u have to load table 1.in that you just write visitor id as customer id
and after that load table 2 in which you just using mapping load and write fields which you want i.e
customer id and then sales amount.
to do this, visitor id combined with customer id.
hope this will help you.