Concatenate several tables

[#1]

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?

[martynlloyd · Accepted solution]

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

[#3]

Yes, I have...

I did it! Thanks

[sudeepkm]

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?

[#5]

thanks Sudeep, It just work fine!