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 !

[#2]

Could show show me how the script would loook like, it's very clear... ?

[er_mohit]

a:

LOAD [visit date],

     [visitor id] as [customer id],

     [order id],

     [visit source],

     [visit no]

   FROM

C:\Users\Mohit\Desktop\Community.xlsx

(ooxml, embedded labels, table is table1);

b:

LOAD *;

mapping load [customer id],

[sales amount]

FROM

C:\Users\Mohit\Desktop\Community.xlsx

(ooxml, embedded labels, table is table2);

[#4]

Thanks for the insight but again Visitor ID is different from Customer ID...

[sujeetsingh]

Give a sample if possible

[er_mohit]

see the attached files.

[#7]

Thanks a lot for your time !

I'm on the free version of qlikview, do you mind copy / pasting the script

you made ? The excel structure is completely fine...

Regards,

[er_mohit]

on the basis of this excel file it works fine....

but i don't know why it didnot works according to you.....

[#9]

I can't test what you sent, my version of qlikview doesn't open extranal

files. Do you mind just copy pasting the script you made on this thread ?

[er_mohit]

see this script..

a:

LOAD [visit date],

     [visitor id] as [customer id],

     [order id],

     [visit source],

     [visit no]

    FROM

C:\Users\Mohit\Desktop\Community.xlsx

(ooxml, embedded labels, table is table1);

b:

LOAD *;

mapping load [customer id],

[sales amount]

FROM

C:\Users\Mohit\Desktop\Community.xlsx

(ooxml, embedded labels, table is table2);

hope it will help you...

[#11]

Thanks a lot ! Will try it !