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 !
you should have marked this either helpful or correct answer. so, that it might be helps to numbers of developers..
its so simple i believe
you can load two mapping tables
Table1:
mapping
Load
Order ID ,Customer ID
from path
Table2:
mapping
Load Order ID ,Sales amounts
from path
Load
Visit date ,visitor ID ,Order ID, Visit source ,Visit number
apply map('Table1',Order ID) as CustomeID
apply map('Table2',Order ID) as CustomeID
from path
Please check the syntax of applymap using help
hope this helps
Looks interesting, let me try that...