topic Re: loading qvd in single load in QlikView

loading qvd in single load

Wed, 19 Aug 2015 16:41:06 GMT

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.

Re: loading qvd in single load

swuehl — Wed, 19 Aug 2015 16:48:49 GMT

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.

Re: loading qvd in single load

maxgro — Wed, 19 Aug 2015 16:53:11 GMT

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;

Re: loading qvd in single load

Wed, 19 Aug 2015 16:55:12 GMT

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

Re: loading qvd in single load

cotiso_hanganu — Wed, 19 Aug 2015 16:58:33 GMT

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)