different named files converted in to one qvd

[#1]

hi

i have a system that generates data files...per day there are large number of files been generated with a different name. the data in this files will be sent to one .qvd as long as i know when converting in to the qvd the newly generated file has to be in same name.. but in my case the first bit of the file name is same but the last bit is always different.

i need this data to be saved to the qvd file no matter what name the other files are from... can some one plz give me a solution for this .would really really appreciate the help plz......

thank you in advance

[tresesco]

Try like:

MergedTable:

Load * From <table1>;

Concatenate                       // if the tables are having identical fields this would not be required

Load * From <table3>;

Concatenate

...

Load * From <tablen>;

Store MergedTbale into MergedTable.qvd(qvd);

[#3]

hi tresesco

i am really sorry for taking so long to replying to this....

i am little not sure whether this will work or not... cz the files are generated dynamically and it has different names except for the first 3 words of the file name.. and per day there are more than 20 files been generated...

so will this method that you have mentioned above work??

[jagan]

Hi,

Try like this using Wild card characters

MergedTable:

Load *

From XXX*.*;

Store MergedTbale into MergedTable.qvd(qvd);

Note : Replace XXX with your first 3 characters of the filename which is same for all the files.

Hope this helps you.

Regards,

Jagan.

[#5]

hi Jagan

converting in to a qvd is done normal way right??  and afterwords when merging the rest of the files to the qvd is done as you said right??

[jagan]

Hi,

MergedTable:

Load *

From XXX*.*;

Above statement will load and concatenate all files whose name starts with XXX, both load and concatenation is done in a single step.

Store MergedTbale into MergedTable.qvd(qvd);

This statement will store the merged table as QVD.

Hope this helps you.

Regards,

Jagan.

[MarcoWedel]

If you like to add new files to the qvd you first load the qvd and then load the new files that are not yet contained in the qvd (there might be some logic necessary to identify the new files).

afterwards you store the table that now consists of all records of the 'old' qvd and of the newly added files.

regards

Marco