Store existing

[Anonymous]

How does one go about exporting data that's already part of the app?

For example, I have previously loaded data in a table called "Delivery", and at the beginning of the script I want to export it.

I tried this

which resulted in

All the examples I've found are using Store after tables are loaded in the script, in this case I want to export what I have first before importing anything.

Regards,

Mike

[vlad_komarov · Accepted solution]

Mike,

Do not worry about "novice" part. You are doing pretty good for the guy without any official training... 🙂

For your case:

1. You can always do a full reload for the data you are getting every week. It simplifies the script development and limits sync issues. Disadvantages: the load might take too long...

2. You can do an incremental load for a new data (if you don't need to "update" the existing records and just load the portion for the current week). In this case you can create a new field in the script:

//Initial LOAD

Data:

Load

....

num(date_field) as Current_Date

// or date(date_field) as Current_Date

from (RAW_DATA_SOURCE);

//Assuming you do have some kind of "date_field" in your data....

// store the result data

STORE DATA into DATA.QVD (qvd);

// incremental load

// load the existing data first

DATA:

LOAD

*

From DATA.QVD;

vToday = num(today());

// LOAD data from new week

Data:

Load

....

num(date_field) as Current_Date

from (RAW_DATA_SOURCE)

where Current_Date > $(vToday)

;

Again, it might complicate your script and needs to be carefully structured (especially considering dates' fields),

but it should help you to reduce the loading time significantly.

Regards,

VK