loading qvd in single load

[#1]

Hi

  I have two qvds in different folders.i.e the same drive but folders are different.

the fields in two qvds are same

here i want to load these qvds in single load.

i tried by using for each but it is loading only one qvd

thanks.

[swuehl]

Not sure if I understand.

If you want to load two QVDs, you need to LOAD statements (leaving a wildcard LOAD untouched for the moment).

If you then get only one resident table, the tables were most probably auto-concatenated due to same number and names of fields (which I think is what you probably want to have anyway).

Use a NOCONCATENATE LOAD prefix on the second QVD LOAD or a QUALIFY  statement before, if you want the QVDs being loaded into separate tables.

But maybe you want something completely different, please elaborate.

[maxgro · Accepted solution]

for each example (with concatenate)

change folder and file names

set concat='';

for Each file in 'folder1\file1.qvd', 'folder2\file2.qvd'

  table:

  $(concat)

  load * from $(file) (qvd);

  set concat=' concatenate (table) ';

NEXT;

[#4]

Here i have qvds in different folders

e:\qvds...is path in this i have two folders

a and b are the folders

e:\qvds\a\a.qvd

e:\qvds\b\b.qvd

like this

here fields are same  in two qvds but data is different.

.

not a problem if data is get concatenate.but have to load those qvds in single load.

hope its clear

[cotiso_hanganu]

0. Aren't you facing an autoconcatenation situation ?

1.The header of the 2 QVDs you are reading is the same ?

2. If 1=yes, are you asking a forced concatenation (concatenate load) between the 2 ? or any kind of join ?

3. If 1=yes and 2=no+no than the answer to Question 0 is , most likely, YES !

Basicly you have loaded both files, but within a table named as the first file read.

=> read more help regarding autoconcatenation (in deocmunetation, training, or community)