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

Merge....2 excel files in QLIK

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 ? 

5 Replies
Not applicable
Author

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

Not applicable
Author

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

santiago_respane
Specialist
Specialist

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
Partner - Creator
Partner - Creator

Hello,

Qlik associate fields between tables by the name.

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

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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.