topic Re: Incremental Load for No Key Field in QlikView

Incremental Load for No Key Field

Wed, 03 Jul 2013 09:33:53 GMT

Hello,

Is there any way to handle incremental load for a fact table which doesn't have a primary key?

Regards,

Amit

Gysbert_Wassenaar — Wed, 03 Jul 2013 09:39:03 GMT

No. If there's no way to uniquely identify a record it's impossible to tell if it changed.

RedSky001 — Wed, 03 Jul 2013 09:40:17 GMT

You could make a primary key out of all the fields which make a row unique.

e.g.

Hash128([Field 1] & [Field 2] & [Field 3] & [Field 4) as Key

Then use the exists() function to check to see if this has already been loaded.

Then you can drop Key from the display dashboard, so not to take up necessary resources.

This will not always work, depends on how your source data is being updated.

Message was edited by: Mark Sheraton This will only work if you know that fields 1 to 4 uniquely identify a record.

Wed, 03 Jul 2013 10:15:43 GMT

Thank you all.

@ Mohit, - rowno() ? let me think and try the possible logic.