session

[smilingjohn]

Hi All,

there are many audit files as shown in the figure

for different dates which  cannot be taken individually ,

therefore i am writing the below script  please , let me know if this is the correct way to access the files ,

?

Thanks in advance

[qlikviewwizard]

It is correct way.

You can restrict the data to load between dates also.

For example, you wanted load today's date and 3 more previous dates.

You can achive like this:

[balabhaskarqlik]

May be try like this:

for each vFile in FileList('..\Data\*.txt')

     let vQVD = replace(vFile, '.txt', '.qvd');

     if alt(FileSize('$(vQVD)'), 0) = 0 then

          NextFile:

          LOAD

              *

          FROM $(vFile)

          (txt, utf8, embedded labels, delimeter is '\t', msq);

          STORE NextFile INTO [path$(vQVD)]. (qvd);

          DROP TABLE NextFile;

     end if

next

Data:

LOAD

    *

FROM ..\Data\*.qvd (qvd);