Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Have you checked the case in your excel sheet - i.e. Region, region ?
Have you checked the case in your excel sheet - i.e. Region, region ?
Yes, I have...
I did it! Thanks
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?
thanks Sudeep, It just work fine!