Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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 !

32 Replies
sujeetsingh
Master III
Master III

Why using Mapping....

Just forget mapping here

Not applicable
Author

They aren't the same...

Not applicable
Author

Right now, this is what happens, the link only happens when the visit lead to a Purchase:

qlik.png

sujeetsingh
Master III
Master III

Try joining with only Visitor iD

and rename OrderID too to a diffrent allias name

sujeetsingh
Master III
Master III

Place a sample and explain the linking issues in dashboard with textbox,,,

Not applicable
Author

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 ?

er_mohit
Master II
Master II

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

Not applicable
Author

No, they're not. My only common field is order ID

sujeetsingh
Master III
Master III

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 .

er_mohit
Master II
Master II

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.