Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Chain of concatenate

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!

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Chain of concatenate

Have you tried concatenate load resident?

7 Replies

Re: concatenate

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);


talk is cheap, supply exceeds demand
Not applicable

Re: Chain of concatenate

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
Contributor III

Re: Chain of concatenate

Would inverting the steps help?

Table2:

noconcatenate

Load * from source2;

Store Table2 into table2.qvd;

Concatenate(Table2)

Load * from source1;

Regards,

Philippe

MVP
MVP

Re: Chain of concatenate

Have you tried concatenate load resident?

Re: Chain of concatenate

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Chain of concatenate

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!

Not applicable

Re: Chain of concatenate

Thanks!!

Community Browser