Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

incrmental load

Hi

I have a requirement like below. I have an QVD which is 3 months data till yesterday and daily I will get an excel file as a data and it will be override on daily base with the new data. Now here is situation for me

I want  add data to existing QVD with the new data on daily basis.Suppose if I get an excel data today, it has to check November month QVD data and with ID columns(there time stamp or modified date column) and replaced with new data. In the same way if I run this load on December it has to check only December data and modified with excel data.

Here I don't have time stamp column and only having ID column

Please suggest me how to proceed on this.

Regards,

Kumar

10 Replies
t_chetirbok
Creator III
Creator III

Hi, TEST.qvd contains all data, TEST.xlsx contains only today data.

You can load data from qvd without "today" data and concatenate data from xslx with generate field.

Hope, It's helpfull.

Anonymous
Not applicable
Author

Hi,

Thanks for ur reply and not able to open this document

Can you send me again.

Regards,

Kumar

t_chetirbok
Creator III
Creator III

Sorry)

Anonymous
Not applicable
Author

Thanks again for sharing valuable information. Here in my QVD I don't have date column and one more thing it has to check the qvd data on monthly wise. I mean if you run in November month it has to check to check November data and modified that data. If run in December it should check in December and adds to that QVD file.

In my QVD I have columns data like

yearmonth     location   ID

201509

.

.

.

201511            US         1

201511             UK        2

201511             AUS      3

Suppose today i got excel like

yearmonth    location ID

201511          HKG    1

My final output should be like

yearmonth     location   ID

201509

.

.

.

201511            HKG         1

201511             UK        2

201511             AUS      3

So US is replaced with HKG.

So if I run QVD script in December with new data it has to check with December QVD data and any changes are there in QVD it has to modified and should create final QVD.

Once again thanks a lot for ur valuable information

Regards,

Kumar

t_chetirbok
Creator III
Creator III

ok, try this code

Table:

LOAD yearmonth, location, id, AutoNumber(yearmonth&id) as NUM

FROM

TEST.xlsx

(ooxml, embedded labels, table is Лист1);

load

yearmonth, location, id, AutoNumber(yearmonth&id) as NUM

from  TEST.qvd(qvd)

where not Exists(NUM,AutoNumber(yearmonth&id) )

;

Anonymous
Not applicable
Author

Hi ,

As you suggested, I tried to change the logic and ran the QVD loader script. But there is no change in that QVD.

It is updating the values.

Regards,

Kumar

t_chetirbok
Creator III
Creator III

I write in the script

//store Table into TEST.qvd(qvd);

You should uncomment this line

mohammadkhatimi
Partner - Specialist
Partner - Specialist

Hi...

PFA..

Regards,

Mohammad

Anonymous
Not applicable
Author

Hi Mohammad,

Thanks for sharing valuable information. My requirement is not like incremental load. Here it it should modify only current month records and it should not modify any records withe same id  in previous months records.