topic Re: Loop not creating table in QlikView

Loop not creating table

juleshartley — Tue, 18 Feb 2014 11:36:05 GMT

Hi All,

I've obviously missing something obvious here! i have this loop, which is meant to cyle through qvw's stored in a certain directory and return simple file information... however it is not returning a table at all. I have debugged and it steps through the files but no table 'Data' is created!

SET FilePath='*.qvw';

sub DoDir (Dir)

for each File in filelist (Dir&'\'&'$(FilePath)')

SET sFile = $(File);

Data:

Load 'Test' as FileName;

next File

end sub

//Call the procedure "DoDir" to check for files in this directory.

call DoDir ('D:\Work\Reference');

Re: Loop not creating table

Tue, 18 Feb 2014 11:44:05 GMT

Try sth like:

LOAD $(File) as FileName

AUTOGENERATE 1;

You always need a source (a file, a database) or Autogenerate N to populate a table

Fabrice

Re: Loop not creating table

Tue, 18 Feb 2014 11:45:53 GMT

Try using the below script.

SET FilePath='*.qvw';

sub DoDir (Dir)

for each File in filelist (Dir&'\'&'$(FilePath)')

SET sFile = $(File);

Data:

Load 'Test' as FileName

AUTOGENERATE 1;

next File

end sub

call DoDir ('D:\Work\Reference');

Re: Loop not creating table

juleshartley — Tue, 18 Feb 2014 11:56:43 GMT

Thanks both - I knew it would be something like that!