Merge....2 excel files in QLIK

[#1]

i am fighting for an hour with Excel sheet and i am wondering if i can solve my case directly within QLIK.

I am working on a winner list (QLIK winner). People that won and got a BOOKING CODE for a hotel reservation.

My second file its an extract from the reservation system showing which code have been used for when.

Now i need to import all the "check in" dates and "check out" dates to my system, for us to be able to send a reminder to those who did not booked....

any clue how to "mail merge" both files ? 

[#2]

You can just load these two and concatenate them :

QlikTomas:

LOAD kunde_vorname,

     kunde_nachname,

     email,

     leistungstraeger,

     anreise,

     abreise,

     promotion_code

FROM

(ooxml, embedded labels, table is Feuil1);

Concatenate

LOAD [Adresse e-mail],

     Prénom,

     Nom,

     Pays,

     Status,

     [booking code],

     [check-in date],

     [check-out date]

FROM

(ooxml, embedded labels, table is Feuil1);

Thanks

[#3]

thanks for your answer...but how qlik will recognize the common value  ...booking code ?

[santiago_respane]

Hi Jean,

Booking code in QLIK Winner is the same as Promotion Code in QLik Tomas?

What is the common field they have?

In that depends if use a join or a concatenation.

Kind regards,

[vinafidalgo]

Hello,

Qlik associate fields between tables by the name.

The name must be equal in both tables (Excel files).

[MindaugasBacius]

Supposing that Booking code in Winner is common to Promotion Code in Tomas:

TOMAS:
LOAD kunde_vorname, 
     kunde_nachname, 
     email, 
     leistungstraeger, 
     anreise, 
     abreise, 
     promotion_code as [booking code]
FROM

(ooxml, embedded labels, table is Feuil1);


left join (TOMAS)
LOAD [Adresse e-mail], 
     Prénom, 
     Nom, 
     Pays, 
     Status, 
     [booking code], 
     [check-in date], 
     [check-out date]
FROM

(ooxml, embedded labels, table is Feuil1);

In case the logic is for concatenate instead of left join use concatenate statement.