topic Re: Merge....2 excel files in QLIK in QlikView

Merge....2 excel files in QLIK

Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Merge....2 excel files in QLIK

Wed, 25 May 2016 12:15:54 GMT

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

Re: Merge....2 excel files in QLIK

Wed, 25 May 2016 12:19:41 GMT

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

Re: Merge....2 excel files in QLIK

santiago_respane — Wed, 25 May 2016 12:55:03 GMT

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,

Re: Merge....2 excel files in QLIK

vinafidalgo — Wed, 25 May 2016 13:06:35 GMT

Hello,

Qlik associate fields between tables by the name.

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

Re: Merge....2 excel files in QLIK

MindaugasBacius — Wed, 25 May 2016 13:30:45 GMT

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.