topic HOw to write for loop in script side in QlikView

HOw to write for loop in script side

Fri, 18 Oct 2013 09:27:44 GMT

Hi,

I want to write for loop in script side so how to write in qvw file.

kaushiknsolanki — Fri, 18 Oct 2013 09:29:03 GMT

Hi,

The syntax is same.

For i=0 to 10

.........

Regards,

Kaushik Solanki

MayilVahanan — Fri, 18 Oct 2013 09:30:21 GMT

This is one of the example for retrieve all files in folder by using for loop in script

Sub loadfiles(Files)

For Each file in FileList('$(Files)' & '\*.*');

TestLoad:

LOAD '$(file)' AS FilePath,

if(Len(SubField('$(file)','.',-1)) < 8,SubField('$(file)','.',-1),'No Extension') AS FileExtension,

FileSize('$(file)') AS FileSize,SubField('$(file)','\',SubStringCount('$(file)','\')+1) As FileName,

FileTime('$(file)') AS FileTime AutoGenerate 1;

NEXT file;

For Each subdir in DirList('$(Files)' & '\*');

CALL subFunction('$(subdir)')

NEXT subdir;

End Sub

SUB subFunction(Subdir)

For Each sub in DirList('$(Subdir)')

CALL loadfiles('$(sub)')

NEXT sub;

End Sub

Call loadfiles('E:\Qlikview -11')

Drop Tables "*";

hic — Mon, 21 Oct 2013 08:04:05 GMT

There are many ways to do this. For an overview, see Loops in the Script.

HIC