Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate several tables

Hi,

I have several excel sheet wih the same format and I need charge them in 1 table in QV.

I try this, but is not OK:

OPEX:

/* HQ */

LOAD

    Region,

    'IT HQ' as Organization,

    Account,

    Analytic,

    [Supplier Code],

    [Supplier Description],

    Responsable,

    Jan,

    Feb,

    Mar,

    Apr,

    May,

    Jun,

    [Total Ene-Jun],

    Acción,

    Jul,

    Aug,

    Sep,

    [Total Jul-Sep],

    Oct,

    Nov,

    Dec,

    [Total Oct-Dic],

    Total,

    'NA' as Comments

FROM

[\\Path_Sheet1\Sheet1.xlsx]

(ooxml, embedded labels, table is [HQ]);

/* ROEU */

LOAD

    Region,

    Organization,

    Account,

    Analytic,

    [Supplier Code],

    [Supplier Description],

    ' ' as Responsable,

    Jan,

    Feb,

    Mar,

    Apr,

    May,

    Jun,

    0   as [Total Ene-Jun],

    ' ' as Acción,

    Jul,

    Aug,

    Sep,

    0   as [Total Jul-Sep],

    Oct,

    Nov,

    Dec,

    0   as [Total Oct-Dic],

    0   as Total,

    Comments

FROM

[\\Path_Sheet2\Sheet2.xlsx]

(ooxml, embedded labels, table is [ROEU]);

The script charges the first sheet, but in the second one don´t recognize the first field "Region"....

I miss something?

1 Solution

Accepted Solutions
martynlloyd
Partner
Partner

Have you checked the case in your excel sheet - i.e. Region, region ?

View solution in original post

4 Replies
martynlloyd
Partner
Partner

Have you checked the case in your excel sheet - i.e. Region, region ?

View solution in original post

Not applicable
Author

Yes, I have...

I did it! Thanks

sudeepkm
Specialist III
Specialist III

the paths are different is it from the same excel file

[\\Path_Sheet1\Sheet1.xlsx]

[\\Path_Sheet2\Sheet2.xlsx]

can you please send what error message you are getting?

Not applicable
Author

thanks Sudeep, It just work fine!