topic Re: session in QlikView

session

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 16 Jul 2018 07:52:10 GMT

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:

BalaBhaskar_Qlik — Mon, 16 Jul 2018 12:35:53 GMT

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

Data:

LOAD

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