Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

Incremental load without date field

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 Replies
Not applicable

Re: Incremental load without date field

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
Contributor II

Re: Incremental load without date field

Can you send me qvw.

Community Browser