Adding Data to an existing txt-file with store

[#1]

Hi, is there a way adding data to an existing txt or qvd file with store or something else? I'm doing an partial Reload and I wanted to save all new data in the txt-file. The Table in the file and in QlikView is the same.

Best Regards

Ingo Placzek

[#2]

Hi,

You can store the data to an existing QVD or text file.

First load the data from the QVD/text file and store it in a table. Then concat the new data to the QVD table and then finally store the entire contents of the table into a QVD/text file.

the script will look as shown below:

[QVD Data]:
Load *
from a.qvd; //This loads the data from existing QVD into the table 'QVD Data'
concat [QVD Data]
load * from Source.txt; //this concats the new data from text file into table [QVD Data]
store [QVD Data] into Data.qvd; //this stores the final data (QVD data + new data) into the QVD
store [QVD Data] into Data.txt; //this stores the final data (QVD data + new data) into a text file

[#3]

Hi, my Script looks like this, but it doesent work, he don't know the concat:

qualify *;

ProAgent:
replace Load * From ProAgent.txt (txt);

concat ProAgent;
add Load *
Resident Status
where ALERTGROUP = 'ProAgent';

Store * from ProAgent into ProAgent.txt (txt);
DROP TABLE ProAgent;

[gandalfgray]

Good Morning!

You have mixed up "concat" with "concatenate"

A small tip: F1

Also you should omit the ";" in the first line of the concatenate statement and have parenthesis:

concatenate (ProAgent)

add Load *

Resident Status

where ALERTGROUP = 'ProAgent';

Try something like that.

[#5]

This one should work

qualify *;

ProAgent:
replace Load * From ProAgent.txt (txt);

concatenate (ProAgent)
add Load *
Resident Status
where ALERTGROUP = 'ProAgent';

Store * from ProAgent into ProAgent.txt (txt);
DROP TABLE ProAgent;