topic Store.... into in QlikView

Store.... into

Fri, 07 May 2010 13:25:15 GMT

Hi, I'm new here, and I'm new with qlikview.

Please, can anybody help? I have to analyze some QV-Scripts, and I wonder, what the commad '...store... into...' will do, if the target file exists. Will it ad the source files to the targed, or will it overwrite? There's no answer about that in the QV-Help.

Thanks for any help,

best Regards

S.Bockelmann

Store.... into

Fri, 07 May 2010 15:14:32 GMT

Hello,

It will overwrite the existing file.

Steve

Store.... into

Mon, 10 May 2010 07:48:47 GMT

Hi Steve,

thanks for that info. Is there a way to add data to an existing file? It's not important for me at the moment, it's just for interest.

best regards

Stefan

Store.... into

Tue, 11 May 2010 15:13:00 GMT

Hello Stefan,

As far as I know there's no way to add records into the existing qvd. If you want to use the same QVD name you could do something like this:

TempA: // load the first QVD into temporary table TempA

LOAD *

FROM 1.QVD (QVD);

TempA: // load the second QVD into the same temporary table TempA

LOAD *

FROM 2.QVD (QVD); // 2.QVD has the new data you want to add to the original 1.QVD. Instead 2.QVD you can use a SQL expression.

STORE TempA INTO 1.QVD;

That way you're going to store the whole data into one single QVD (1.QVD)

Steve

Store.... into

Tue, 11 May 2010 16:16:54 GMT

ok, many thanks...

hope I can need this any time.

best regards

Stefan