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)
