Discussion Board for collaboration on QlikView Scripting.
Hello there !
I have 2 tables, one with my visit logs on my site and structured as:
Visit date | visitor ID | Order ID | Visit source | Visit number
One with my sales data as:
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 !
No unfortunately. Visitor ID is the ID allocated to users on my site.
Customer ID is the ID allocated to users in my sales system.
One customer ID will probably have several visitor IDs...
Thank you !!
I've already tried a join and a left join with no success. What kind of
join do you think about ?
Right now all my file has is:
(txt, utf8, embedded labels, delimiter is ',', msq);
(txt, codepage is 932, embedded labels, delimiter is ',', msq);
Just Load Table1....in a Temp table
Finaly qlikview will join the both tables itself.....by Synthetic key
Else you want to do it at more advanced level...you can proceed as follow
outter join (Table1)
Hope it will help you....
u can create key like this,
Visit date , visitor ID , Order ID as Key_Order, Visit source , Visit number
Order ID as Key_Order, Customer ID , Sales amounts
or you can join the table like below
visitor ID , Order ID, Visit source , Visit number
Order ID, Customer ID , Sales amounts
Thanks ! Already tried the 1st method but it only allocated the visitor ID
correctly when there is a purchase (and thus a link on Purchase ID). I need
it to link visitor ID and Customer ID even when there's no Purchase ID...
I tried adding the join but the result is the same:
It only allocated the visitor ID correctly when there is a purchase (and
thus a link on Purchase ID). I need it to link visitor ID and Customer ID
even when there's no Purchase ID... (sorry I'm copy/pasting the reply I
already made above).
Thanks for helping !