topic Scipt in QlikView

Scipt

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

Hi All ,

Can someone please explain me the below script

IF isNull(fileSize('$(vExcelPath)$(vfile_EC_Compliance)*.xlsx'))THEN

[RAW DATA]:

LOAD

iEvalID,

iFormID,

Date,

FROM $(vQVDPath)RAW.qvd

(qvd);

DIRECTOR:

LOAD * FROM $(vQVDPath)DIRECTOR.qvd(qvd);

exit script;

Else

Get_File:

load

FileName() as excels,

mid(FileName(),34,6) as Year_Month,

EndIf

Max_Download:

load

max(Year_Month) as Max_Year_Month,

MAX(%FileNo) as %MaxFileNo,

MAX(Year_Month_Week) as %Year_Month_Week

Resident Get_File;

Thanks in advance

Re: Scipt

Anonymous — Wed, 05 Jul 2017 12:21:31 GMT

Hi John,

This is a procedure used to load data.

It looks at the COmpliance excel file. and checks if it contains data or not. If it does, it will load the data from there.

If not, it then goes to a raw data file called DIRECTOR.qvd ans RAW DATA.qvd

inside of it, it takes the month and year of a certain period defined in one of your variables, filters it out ,combines it and creates its own data table for the qvw to read.

Hope this makes sense.

Re: Scipt

jmvilaplanap — Wed, 05 Jul 2017 14:27:12 GMT

I think there is not the complete script, because is doing reference to things that are not here.

And at the end of the script, use the Get_File resident table, but no always it will be created, depending if the xlsx file exist or not.

Get File table is not complete, because need a resident or autogenerate or something to be created. Is it working? I think is not possible.