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
