Store.... into

[#1]

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

[#2 · Accepted solution]

Hello,

It will overwrite the existing file.

Steve

[#3]

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

[#4]

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

[#5]

ok, many thanks...

hope I can need this any time.

best regards

Stefan