Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
This application attached is working from many days , suddenly getting General Script error. Please see the attached log file and kindly help.
Thanks,
AS
I would comment out the last reload excel 'Hierarchie.xlsx' and retry. If it goes fine, have a look at that file; refresh it; save it and retry with full script.
Tresesco,
I found one strange issue , if I use F: drive path to call script below it is showing general script error but If I comment this and run this script from 😧 drive path it is working fine . Could you please suggest what could be issue here.
//for each file in filelist('D:\QlikView\Development\Finance\#Source\Flatfiles\Sonne\Source\*')
for each file in filelist('F:\QlikView\Server\SourceDocuments\Finance\#Source\Flatfiles\Sonne\Source\*')
Sales_Data_Temp:
CrossTable(Sales_Month, Sales_Data,2)
LOAD
subfield(subfield('$(file)', '\' ,10),'.',1) as Sales_Year ,
trim(Plant) as %Plant,
Jan,
Feb,
Mar,
Apr,
May,
Jun,
Jul,
Aug,
Sep,
Oct,
Nov,
Dec
/* F14,
F15,
F16,
F17,
F18,
F19,
F20,
F21,
F22,
F23,
F24,
F25,
F26,
F27,
F28,
F29
*/
FROM
[$(file)]
(ooxml, embedded labels, table is Sales, filters(
Remove(Row, Pos(Top, 8)),
Remove(Row, Pos(Top, 7)),
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Col, Pos(Top, 1)),
Remove(Col, Pos(Top, 3)),
Remove(Col, Pos(Top, 2)),
Remove(Col, Pos(Top, 15)),
Remove(Col, Pos(Top, 14)),
Remove(Col, Pos(Top, 34)),
Remove(Col, Pos(Top, 33)),
Remove(Col, Pos(Top, 32)),
Remove(Col, Pos(Top, 31)),
Remove(Col, Pos(Top, 30)),
Remove(Col, Pos(Top, 29)),
Remove(Col, Pos(Top, 28)),
Remove(Col, Pos(Top, 27)),
Remove(Col, Pos(Top, 26)),
Remove(Col, Pos(Top, 25)),
Remove(Col, Pos(Top, 24)),
Remove(Col, Pos(Top, 23)),
Remove(Col, Pos(Top, 22)),
Remove(Col, Pos(Top, 21)),
Remove(Col, Pos(Top, 20)),
Remove(Col, Pos(Top, 19)),
Remove(Col, Pos(Top, 18)),
Remove(Col, Pos(Top, 17)),
Remove(Col, Pos(Top, 16)),
Remove(Col, Pos(Top, 15)),
Remove(Col, Pos(Top, 14)),
Top(1, 'Plant')
));
Thanks,
AS
It could be access/path issue. Try to explore the file once again from the script editor browser and retry.