topic script advise in QlikView

script advise

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to load my text files incrementally.

Files like File18082016.txt,File19082016.txt,File20082016.txt,..

Delete script is not working.

Please correct the script.

Let ThisExecTime = Now( );
QV_Table:
LOAD *,FileName() as FileName,
FileTime() as FileTime
FROM
[..\Source Files\File*.txt]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
WHERE FileTime() >= '$(LastExecTime)'
AND FileTime() < '$(ThisExecTime)';
Concatenate
LOAD *
FROM
[QV_Table.qvd]
(qvd)
WHERE NOT EXISTS(FileName);
//Inner Join
//LOAD FileTime() as FileTime
//FROM
//[..\Source Files\File*.txt]
//(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
If ScriptErrorCount = 0 then
STORE QV_Table INTO QV_Table.qvd(qvd);
Let LastExecTime =ThisExecTime;
End If
EXIT Script;

Re: script advise

Gysbert_Wassenaar — Thu, 18 Aug 2016 07:26:03 GMT

Perhaps these works:

Let ThisExecTime = num(Now());

QV_Table:
LOAD *,FileName() as FileName,
FileTime() as FileTime
FROM
[..\Source Files\File*.txt]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
WHERE num(FileTime()) >= $(LastExecTime)
AND num(FileTime()) < $(ThisExecTime);

Re: script advise

Thu, 18 Aug 2016 07:46:07 GMT

Hi Gysbert,

How this will work =$(LastExecTime)? As we didn't have declare the variable?

Re: script advise

Gysbert_Wassenaar — Thu, 18 Aug 2016 07:51:52 GMT

You declare it at the end of the script. That's when it gets a value. That variable will still exist and have that value the next time you execute the script.

Re: script advise

Thu, 18 Aug 2016 08:38:43 GMT

Hi Gysbert,

Seems this is not working.

Please test with the attached files.

Let ThisExecTime = num(Now( ));
QV_Table:
LOAD *,FileName() as FileName,
FileTime() as FileTime
FROM
[..\Source Files\File*.txt]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)
WHERE num(FileTime()) >= '$(LastExecTime)'
AND num(FileTime()) < '$(ThisExecTime)';
Let LastExecTime =num(ThisExecTime);

Re: script advise

Gysbert_Wassenaar — Thu, 18 Aug 2016 09:11:25 GMT

Remove the single quotes in the where clause.

Re: script advise

Thu, 18 Aug 2016 09:44:40 GMT

I have done but still the data is not loading. Please help me full script.

Re: script advise

Gysbert_Wassenaar — Thu, 18 Aug 2016 09:49:50 GMT

Let ThisExecTime = num(Now());

QV_Table:

LOAD

FileName() as FileName,

FileTime() as FileTime

FROM

[File*.txt]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

WHERE

num(FileTime()) >= $(LastExecTime)

AND num(FileTime()) < $(ThisExecTime)

;

Let LastExecTime = num(ThisExecTime);