Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: 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 - Specialist III
Partner - Specialist III

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 - Specialist III
Partner - Specialist III

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