Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 - Creator III
Partner - Creator III

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

View solution in original post

4 Replies
martynlloyd
Partner - Creator III
Partner - Creator III

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

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!