Create a Qvd for N-number of files

[#1]

Hi all,

How r u?

In my machine having an Folder with multiple Text Files, i.e; for now consider 4 files present those FilesNames are ABC, DEF, 123, XYZ.

In future there might be more files in the folder.

NOTE:

1.) All the files are having same columns and having same PrimaryKey for all files.

2.) The File Names will not be static.

Now i need to create a single QVD for all these files . That is if N number of Files are having in my folder, then for all the N-files i need to CONCATENATE and create a single QVD File for them.

See the below sample data file format, PrimaryKey = ID.

For ABC File having the Data of below:

ID, Name, Marks

1,  sa, 80

2,  va, ,90

3,  ba, 70

4, da, 100

For DEF File having the below Data:

ID, Name, Marks

5, bb, 20

6, cb, 30

7, eb, 50

For 123 File having below Data:

ID, Name, Marks

8, af, 10

9, gf, 40

For XYZ File having below Data

ID, Name, Marks

10, gg, 70

Thanks in Advance

Regards

Venkat

[#2]

i think with for each it will work.

here an idea:

for each File in filelist (directory)

Load-Statment ....

store into ....

next File

watch in the help search for "for each... next" there is an example that should help you