Incremental Load on a column with data type as alpha numeric

[Anonymous]

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

[sushil353]

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

[Anonymous]

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

[tresesco]

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

[#5]

A small correction in your script

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

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

[Anonymous]

i ddint get u tresesco

[Anonymous]

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

[tresesco]

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.