Mapping

[#1]

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 !

[er_mohit]

you should have marked this either helpful or correct answer. so, that it might be helps to numbers of developers..

[SunilChauhan]

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

[#4]

Looks interesting, let me try that...