topic Re: Read QVD names and store in temp table in App Development

Read QVD names and store in temp table

soumroy7 — Sat, 16 Nov 2024 04:38:16 GMT

Hi,

I am currently loading multiple QVDs(12 QVDs for each month) via for Loop in script. Filenames are like:

ABC_2019_01, ABC_2019_02 ..... and so on.

================================================

LET vFile='[ABC_*.qvd]';

FOR EACH vFile in FileList('ABC_*.qvd')

Load * FROM $(vFile)(qvd);

Next vFile;
NEXT vFile;

Till now it works fine. Now I want to read the latest filename (e.g. - 'ABC_2019_09') and store this QVD File Name in a temp table.

Can anyone help me with an example script for this

Soumya

Vegar — Wed, 18 Sep 2019 16:15:07 GMT

LET vFile='[ABC_*.qvd]';

FOR EACH vFile in FileList('ABC_*.qvd')

Load * FROM $(vFile)(qvd);

FileList:

Load

'$(vFile)' as FileName,

QvdNoOfRecords('$(vFile)') as NoOfRecords,

QvdNoOfFields('$(vFile)') as NoOfFields

Autogenerate 1;

Next vFile;

soumroy7 — Wed, 18 Sep 2019 17:12:00 GMT

Thanks a lot. This helps

soumroy7 — Wed, 18 Sep 2019 17:12:48 GMT

Thanks a lot. This helps alot

Vegar — Wed, 18 Sep 2019 17:15:52 GMT

That's great to hear.

I usually do something like this for every qvd I store in my extract and transform applications.