topic Re: Incremental load without date field in QlikView

Incremental load without date field

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Incremental load without date field

Tue, 12 Jul 2016 07:22:28 GMT

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

Re: Incremental load without date field

panipat1990 — Tue, 12 Jul 2016 08:33:07 GMT

Can you send me qvw.