Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
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
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
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');
Thanks both - I knew it would be something like that!