Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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