Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to keep my data every day. To add a new row. To use in tracking
From my code, I stored Data.xlsx into Archive_Data.qvd.
It replaces old data, which is in Archive_Data.qvd. I want to keep the data in a new row.
Excemple
// Date 1/7/2108 There is data.
Article Stock
D1100 300
D1200 400
D1300 500
// Date 2/7/2108 There is data.
Article Stock
D1100 250
D1200 3500
D1300 4500
// Result in Archive_Data.qvd is
Article Stock
D1100 300 // Date 1/7/2108
D1200 300 // Date 1/7/2108
D1300 300 // Date 1/7/2108
D1100 250 // Date 2/7/2108
D1200 350 // Date 2/7/2108
D1300 450 // Date 2/7/2108
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Data:
LOAD Article,
Stock,
today() as date
FROM
(ooxml, embedded labels, table is Sheet1);
//_____________________________________________________________________________//
Archive_Data:
LOAD *;
IF NOT IsNull(QvdCreateTime('Data.qvd')) THEN
CONCATENATE (Data)
LOAD * FROM Data.qvd (qvd);
ENDIF
STORE Data INTO Archive_Data.qvd (qvd);
//_____________________________________________________________________________//
STORE Data INTO Archive_Data.qvd (qvd);
Load_Archive_Data:
LOAD Article,
Stock
FROM
(qvd);
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Plese help me