Extract File - Multiple file upload issues

[#1]

I have a script which extracts information and saves it in the format that I require but the only trouble is that this only works with a single file upload. I have lots of spreadsheets to extract all with the word timetable in I should be able to just do a *timetable* command.

The command appears to work but there seems to be something wrong with the script itself and the script stalls and doesnt complete the upload

Ive attached a copy of the extract QVW and three source files

Help

PS the extract file fills in the blank lines on the left hand side this is what i need it to do

[its_anandrjs]

In your load script add to commands

FileBaseName as FileBaseName,

FileName() as FileName

and check how many files getting loaded

[#3]

None get loaded QlikView crashes on load

[rustyfishbones]

It's crashing because they are not csv files, they are excel files

[its_anandrjs]

Then files that you provide it is xls file please check attached and use this commands in load script for check how many files loaded

Load

FileBaseName as FileBaseName,

FileName() as FileName

From Location;

[rustyfishbones]

Yes you can use *timetable*.xls

[its_anandrjs]

On the load script you can try this also

FROM

M:\GVK WIP\TMS\TT\*Timetable*.xls

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[rustyfishbones]

Glenn you need to check your STORE procedure.

You have not defined it as a qvd

you have

STORE TMSData INTO TMSData.QVD;

it should be

STORE TMSData INTO TMSData.QVD(qvd);

[#9]

Thanks.. missed that one, changed the line you suggested by it still doesnt work 😞

[#10]

I've already got that command in