Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rdlccn70
New Contributor II

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

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

Is this what you are looking for?

7 Replies
felipedl
Valued Contributor III

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

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
New Contributor II

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

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

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

Is this what you are looking for?

felipedl
Valued Contributor III

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

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

Maybe you want something different?

rdlccn70
New Contributor II

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

i will check it on monday. Thanks in advance.

rdlccn70
New Contributor II

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

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

rdlccn70
New Contributor II

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

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

Community Browser