Scipt

[smilingjohn]

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

[Anonymous · Accepted solution]

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.

[jmvilaplanap]

Hi

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.