topic Re: incrmental load in QlikView

incrmental load

Anonymous — Fri, 20 Nov 2015 09:28:27 GMT

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

Re: incrmental load

t_chetirbok — Fri, 20 Nov 2015 10:41:25 GMT

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.

Re: incrmental load

Anonymous — Fri, 20 Nov 2015 11:21:06 GMT

Hi,

Thanks for ur reply and not able to open this document

Can you send me again.

Regards,

Kumar

Re: incrmental load

t_chetirbok — Fri, 20 Nov 2015 11:23:13 GMT

Sorry)

Re: incrmental load

Anonymous — Fri, 20 Nov 2015 11:43:05 GMT

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

Re: incrmental load

t_chetirbok — Fri, 20 Nov 2015 11:54:46 GMT

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) )

;

Re: incrmental load

Anonymous — Mon, 23 Nov 2015 08:56:19 GMT

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

Re: incrmental load

t_chetirbok — Mon, 23 Nov 2015 09:01:20 GMT

I write in the script

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

You should uncomment this line

Re: incrmental load

mohammadkhatimi — Mon, 23 Nov 2015 09:02:45 GMT

Hi...

PFA..

Regards,

Mohammad

Re: incrmental load

Anonymous — Mon, 23 Nov 2015 09:13:30 GMT

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.

Re: incrmental load

Anonymous — Mon, 23 Nov 2015 09:24:12 GMT

Hi all,

I want to update to existing QVD value with the value which is available in Excel sheet. Please anyone help me.

Regards,

Kumar