Concatenate several tables

Fri, 18 Jul 2014 13:33:19 GMT

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?

Re: Concatenate several tables

martynlloyd — Fri, 18 Jul 2014 13:36:18 GMT

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

Re: Concatenate several tables

Fri, 18 Jul 2014 13:43:00 GMT

Yes, I have...

I did it! Thanks

Re: Concatenate several tables

sudeepkm — Fri, 18 Jul 2014 13:49:41 GMT

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?

Re: Concatenate several tables

Fri, 18 Jul 2014 14:09:44 GMT

thanks Sudeep, It just work fine!

topic Re: Concatenate several tables in QlikView

Concatenate several tables

Re: Concatenate several tables

Re: Concatenate several tables

Re: Concatenate several tables

Re: Concatenate several tables