Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rdlccn70
Contributor III
Contributor III

Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

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_IDCUSTOMERYEARSalesAmount
1AAAA20151.000
2BBBB20152.000
3CCCC20153.000
2. TABLE
CUSTOMER_IDCUSTOMERYEARSalesAmount
1AAAA20165.000
2BBBB20166.000
3CCCC20167.000
4DDDD20168.000
3. TABLE
CUSTOMER_IDCUSTOMERYEARSalesAmount
1AAAA20176.000
2BBBB20177.000
3CCCC20178.000
4DDDD20179.000
5EEEE201710.000
4. TABLE
CUSTOMER_IDCUSTOMERCOUNTRY
1AAAAUSA
2BBBBCHINA
3CCCCGERMANY
4DDDDMEXICO
5EEEE

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

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Is this what you are looking for?

View solution in original post

7 Replies
felipedl
Partner
Partner

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
Contributor III
Contributor III
Author

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
Champion III
Champion III

Is this what you are looking for?

felipedl
Partner
Partner

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

Maybe you want something different?

rdlccn70
Contributor III
Contributor III
Author

i will check it on monday. Thanks in advance.

rdlccn70
Contributor III
Contributor III
Author

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

rdlccn70
Contributor III
Contributor III
Author

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