Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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);