Discussion Board for collaboration related to QlikView App Development.
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:
/* HQ */
'IT HQ' as Organization,
'NA' as Comments
(ooxml, embedded labels, table is [HQ]);
/* ROEU */
' ' as Responsable,
0 as [Total Ene-Jun],
' ' as Acción,
0 as [Total Jul-Sep],
0 as [Total Oct-Dic],
0 as Total,
(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 ?
View solution in original post
Yes, I have...
I did it! Thanks
the paths are different is it from the same excel file
can you please send what error message you are getting?
thanks Sudeep, It just work fine!