topic Re: Re: Incremental Load on a column with data type as alpha numeric in QlikView

Incremental Load on a column with data type as alpha numeric

Anonymous — Wed, 09 Apr 2014 09:47:04 GMT

Hi everyone,

I have a data with one column and its data type is alpha numeric. I want to use incremental load on that column. I tried using RecNo() function , but when I apply my incremental function on it, it is not recognizing RecNo(),

Please help me with this..

Thanking everyone in anticipation

Re: Incremental Load on a column with data type as alpha numeric

sushil353 — Wed, 09 Apr 2014 09:53:20 GMT

could you post the part of your script where you are getting issue?

Re: Incremental Load on a column with data type as alpha numeric

Anonymous — Wed, 09 Apr 2014 10:03:12 GMT

below u can find the table loading. in table A i had only column field, I added a Rec Column which will calculate the record no.

LOAD Column,

RecNo() as Rec

FROM

(ooxml, embedded labels, table is Sheet1);

STORE A INTO A.QVD(QVD);

after the qvd is made i used in different qvw to aaply my incremental load

MAX:

LOAD

MAX(Rec) AS MAX_Rec

FROM

C:\Users\SoniK\Desktop\A.QVD

(qvd);

LET VMAX=PEEK('MAX_DATE',0,'MAX');

TEMP:

LOAD Column,

Rec

FROM

C:\Users\SoniK\Desktop\A.QVD

(qvd);

Concatenate

LOAD Column,

RecNo() as Rec

(ooxml, embedded labels, table is Sheet1)

WHERE Rec> $(VMAX);

error

field not found Rec in TEMP

Re: Incremental Load on a column with data type as alpha numeric

tresB — Wed, 09 Apr 2014 10:15:55 GMT

Load the qvd separately (with load *) and check if the field is actually there.

Re: Re: Incremental Load on a column with data type as alpha numeric

Wed, 09 Apr 2014 10:19:19 GMT

A small correction in your script

LET VMAX=PEEK('MAX_DATE',0,'MAX'); //not this

LET VMAX=PEEK('MAX_Rec',0,'MAX'); //use this

Re: Incremental Load on a column with data type as alpha numeric

Anonymous — Wed, 09 Apr 2014 10:20:05 GMT

i ddint get u tresesco

Re: Re: Incremental Load on a column with data type as alpha numeric

Anonymous — Wed, 09 Apr 2014 10:21:16 GMT

hey ravi i used ur code only but by mistake i copied this ..

Re: Incremental Load on a column with data type as alpha numeric

tresB — Wed, 09 Apr 2014 11:09:08 GMT

Take a new test app and try loading like:

Load

From

C:\Users\SoniK\Desktop\A.QVD

(qvd);

And then check if the Rec column is there or not.