Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I just tunned a file to do an incremental load from a Analytics excel.
The problem is in the incremental Load script tab. As all the Analytics info has no key field, I would like to load the present day and present day - 1 info, just to have all the date up to date.
Any body can help to me with the script?
Many thank's
Eduard
Something like this:
// Load recent data
Data:
LOAD ....
FROM ...xlsx (ooxml, ...)
Where Date = Today() Or Date = Today() - 1;
// Load past data from qvd
LOAD *
FROM .......qvd (qvd)
Where Date < Today() - 1;
// Update qvd
STORE Data Into .....qvd (qvd);
(Change the date field to the appropriate field name, and make sure that the date field is loaded as a proper Qlikview date and not as a string)
According to date u can add new data to the existing Qvd
first u have convert the date formate
let vupdatedate = peek('Anal_date)', -1, 'table name');
where Anal_date >= $(vupdatedate);
Something like this:
// Load recent data
Data:
LOAD ....
FROM ...xlsx (ooxml, ...)
Where Date = Today() Or Date = Today() - 1;
// Load past data from qvd
LOAD *
FROM .......qvd (qvd)
Where Date < Today() - 1;
// Update qvd
STORE Data Into .....qvd (qvd);
(Change the date field to the appropriate field name, and make sure that the date field is loaded as a proper Qlikview date and not as a string)