Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

karunpreet
Contributor II

Incremental Load on a column with data type as alpha numeric

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

7 Replies
sushil353
Honored Contributor II

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

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

karunpreet
Contributor II

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

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.

A:

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

MVP
MVP

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

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

Not applicable

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

A small correction in your script

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

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

karunpreet
Contributor II

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

i ddint get u tresesco

karunpreet
Contributor II

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

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

MVP
MVP

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

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.

Community Browser