topic Load only Latest two months files in App Development

Load only Latest two months files

379SSS — Fri, 15 Nov 2024 21:53:50 GMT

Hi All,

Can anyone help me on below requirement.

I have multiple Qvd files with naming as below

1.Products_New_202201.qvd
2.Products_New_202112.qvd
3.Products_New_202111.qvd
4.Products_New_202110.qvd

Here I need to load only latest two months files from the folder also files don't have the date fields.

please help me on this

Re: Load only Latest two months files

Kushal_Chawda — Fri, 14 Apr 2023 15:01:01 GMT

@379SSS try below

let vFolderPath ='lib://Store QVD/Data';

Files:
first 1 LOAD
SubField(FileBaseName(),'_',-1) as FileMonth,
FileName() as FileName
FROM [$(vFolderPath)/Products_New_*.qvd]
(qvd);

Latest2Months:
first 2 load FileName
Resident Files
Order by FileMonth desc;

Drop Table Files;

Data:
Load 0 as Temp
AutoGenerate 0;

for i=1 to FieldValueCount('FileName')

let vFileName = FieldValue('FileName',$(i));

Concatenate(Data)
Load *
FROM [$(vFolderPath)/$(vFileName)]
(qvd);

Drop Field Temp;

Drop Table Latest2Months;

Re: Load only Latest two months files

379SSS — Sun, 16 Apr 2023 10:48:33 GMT

Thanks! @Kushal_Chawda . It's working now 😊