Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

[rdlccn70]

Hi, i have a simple problem. I will join 4 excel tables.

The first 3 tables are the same in the structure. The fourth table have some more information about the customer

1. TABLE
CUSTOMER_ID	CUSTOMER	YEAR	SalesAmount
1	AAAA	2015	1.000
2	BBBB	2015	2.000
3	CCCC	2015	3.000
2. TABLE
CUSTOMER_ID	CUSTOMER	YEAR	SalesAmount
1	AAAA	2016	5.000
2	BBBB	2016	6.000
3	CCCC	2016	7.000
4	DDDD	2016	8.000
3. TABLE
CUSTOMER_ID	CUSTOMER	YEAR	SalesAmount
1	AAAA	2017	6.000
2	BBBB	2017	7.000
3	CCCC	2017	8.000
4	DDDD	2017	9.000
5	EEEE	2017	10.000
4. TABLE
CUSTOMER_ID	CUSTOMER	COUNTRY
1	AAAA	USA
2	BBBB	CHINA
3	CCCC	GERMANY
4	DDDD	MEXICO
5	EEEE	CANADA

So my question is how can i merge this four tables to one table in Qlikview.

I think it should be solved by concatenate and/or joining anyway however.

Thank you in advance.

Erdal

[felipedl]

Do something like this

Table1:

Load

     *

From [Excel1];

// Will automatically concatenate since the table has the same structure as Table1

Load

     *

From [Excel2];

// Will automatically concatenate since the table has the same structure as Table1

Load

     *

From [Excel3];

left join (Table1)

Load

     CUSTOMER_ID,

     CUSTOMER,

     COUNTRY

From [Excel 4];

[rdlccn70]

I have tried this myself, this is not working. The problem is that you have to concatenate the first three tables and then join it with the 4. Table, but i didn't find the workaround.

[vishsaggi · Accepted solution]

Is this what you are looking for?

[felipedl]

Just like Vishwarant made it, i've got the same result.

Maybe you want something different?

[rdlccn70]

i will check it on monday. Thanks in advance.

[rdlccn70]

Thank you, i think it works. I will check it again with the whole context.

[rdlccn70]

Hi Felip, thank you again. I will check your help also. May be i make a mistake. I will check it and response you. Regards,

Erdal