topic Re: Load the last QVD in a certain folder in QlikView

Load the last QVD in a certain folder

shaybitton — Wed, 20 Jul 2016 11:36:27 GMT

Hi all,

Module A is generating a QVD file in the 5th and 10th day in each month, and named as that date - '07102016' (for example) to SHAY folder

module B supposed to contain and reload the last QVD generated to the SHAY folder and reload in the above dates ( 5, 10 )

how should i do it?

thanks in advance

boorgura — Wed, 20 Jul 2016 14:23:50 GMT

If I understand correctly,

you are adding 2 QVDs per month to FOLDER-A.

in Folder-B, you only want the latest 2 QVDs?

If naming need not be the same. then you can have the same script to store as 07102016.qvd in FOLDER-A and 10.qvd in FOLDER-B

Next month when 08102016.qvd is created in Folder-A --> In Folder-B, 10.qvd will be replaced.

saimahasan — Thu, 21 Jul 2016 11:17:33 GMT

Can you please elaborate your question??

mohamed_ahid — Thu, 21 Jul 2016 14:22:28 GMT

for Each File in ('folder with QVDs ')

Folder:

LOAD distinct

num(FileBaseName()) as Folder_Name

FROM $(File)

;

next File

max_folder:

load max(Folder_Name) as Last_folder

resident Folder;

let last_folder=FieldValue(Last_folder,0); //this is your last folder