Hi,
I have one big QVD file which is an export of data located in a DB. I do an incremental load updating all the data of the QVD. This works fine, but now I have different QlikView documents (each one belonging to a unique client) and I want to keep them updated as well. In the QVD I have the data of all the clients. How can I do it? I mean, I know how to do it from the DB to the QVD, but in the small documents, how can I load the data of the document to concatenate it with the new one from the QVD? This is the QVD script.
Let lastSessionID = peek('session_id');
sessions:
LOAD
session_id,
session_key,
begin_load,
begin_timestamp,
date(floor(begin_timestamp)) as begin_date,
year(begin_timestamp) as year,
ApplyMap('quarters', month(begin_timestamp)) as quarter,
year(begin_timestamp) & '-' & ApplyMap('quarters', month(begin_timestamp)) as year_quarter,
month(begin_timestamp) as month,
date(MakeDate(year(begin_timestamp), month(begin_timestamp)), 'YYYY-MMM') as year_month,
week(begin_timestamp) as week,
year(begin_timestamp) & '-' & week(begin_timestamp) as year_week,
weekday(begin_timestamp) as weekday,
day(begin_timestamp) as day,
hour(begin_timestamp) as hour,
bot_fk as session_bot_id,
transaction_count,
if(transaction_count - 1 = 0, 'Empty', 'Not Empty') as empty_session,
end_load;
SQL SELECT session_id, session_key, begin_load, begin_timestamp, bot_fk, transaction_count, end_load
FROM dw.f_sessions
WHERE session_id > $(lastSessionID);
Concatenate (MyData)
LOAD *
FROM QVDS\incremental\sessions.qvd (qvd);
STORE *
FROM sessions
INTO QVDS\incremental\sessions.qvd;
************************************************
I want do the same but from QVD to a document. Like:
************************************************
Let lastSessionID = peek('session_id');
table:
LOAD
document DATA
FROM document.qvw
Concatenate (table)
LOAD *
FROM QVDS\incremental\sessions.qvd (qvd)
WHERE session_id > $(lastSessionID);
