topic Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables) in QlikView

Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

rdlccn70 — Fri, 18 Aug 2017 19:49:55 GMT

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

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

felipedl — Fri, 18 Aug 2017 19:54:57 GMT

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];

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

rdlccn70 — Fri, 18 Aug 2017 20:04:59 GMT

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.

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

vishsaggi — Fri, 18 Aug 2017 20:29:11 GMT

Is this what you are looking for?

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

felipedl — Fri, 18 Aug 2017 20:42:15 GMT

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

Maybe you want something different?

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

rdlccn70 — Sat, 19 Aug 2017 00:37:37 GMT

i will check it on monday. Thanks in advance.

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

rdlccn70 — Mon, 21 Aug 2017 09:13:50 GMT

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

Re: Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

rdlccn70 — Mon, 21 Aug 2017 09:15:43 GMT

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