Incremental load without date field

[panipat1990]

Hi Team,

I have a table without date field. i want to Incremental load on this table without date field.. for this i am sharing this table. and when the change of region name.Like Jind to Zind and Bhiwani to Bhawni . One alert automatically come on mail. how is it possible.kindly help me for solving this issue

[#2]

Try using

autonumberhash128 (Code, Name, Region) as KeyID

This would assign a key/id field.

Then using this key, you could employ the following script (or variant thereof):

Original_Table:

Load *,

autonumberhash128 (Code, Name, Region) as KeyID

from File.qvd (qvd);

Concatenate (Original_Table)

Load *

from File.qvd (qvd)

WHERE NOT Exists(KeyID);

Store Original_Table INTO New_Table.qvd;

Hope it helps.

Pravesh

[panipat1990]

Can you send me qvw.