Chain of concatenate

[#1]

Hi there,

i am wondering is there any possibility to do the following chain:

1. Not to concatenate a table to existing(already loaded table from qvd)

2. save it as qvd(store ...)

3. concatenate it to the table from p.1

Appreciate answers and comments!

[Gysbert_Wassenaar]

Basically like this (assuming Table1 and Table2 have exactly the same fields):

Table1:

Load * from source1;

Table2:

noconcatenate

Load * from source2;

Store Table2 into table2.qvd;

Drop Table2;

//concatenate(Table1) //uncomment this line if you need to force concatenation

Load * from table2.qvd (qvd);

[#3]

Wassenaar,

that's an easy solution, thanks for it,

BUT the reason i asked this question is that i don't want to re-load huge amounts of data. Once i have load them from DB to a memory, i want to use them.

So, is there any way to implement my chain the way i asked without reloading from qvd?

Thanks!

[pgrenier]

Would inverting the steps help?

Table2:

noconcatenate

Load * from source2;

Store Table2 into table2.qvd;

Concatenate(Table2)

Load * from source1;

Regards,

Philippe

[rbecher · Accepted solution]

Have you tried concatenate load resident?

[Gysbert_Wassenaar]

Reloading from qvd is often faster than using a resident load. A qvd is basically a memory dump of the table data. An optimized qvd load is very fast. So as long as you don't need to process the data from the qvd further the data should load almost as fast as it can be read from disk.

[#7]

Hi Philippe,

the problem is that the "source1" in my solution is qvd!

(i am using LOAD  OrderDate,   SalesOrderID  FROM Orders_*.QVD (qvd) ).

So, in this situation i need to load all qvds except recently saved from source2.

i don't if the "FROM" keyword accepts some like "from Orders_* except Orders_$(i)".

Thanks!

[#8]

Thanks!!