topic concatenated key not unique in QlikView

concatenated key not unique

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have 2 tables and there is no unique key to link both tables, so i want to create string concatenated key.

The combincation of fields i have choosen seems not generating unique values, as i see duplicate values in the key field.

Then i decided to add a date field like below-

field1 & '|' & field1 & '|' & datefield1 & '|' & datefield12 as key

but when the date is null, then the key showing duplicate values.

Can i write a condition in the above concatenated key? or is there any better way?

Thanks!

sunny_talwar — Tue, 17 Jan 2017 16:06:52 GMT

It might be easier to see what you want if you can share 5-10 lines of data and the kind of key you are looking to create

Tue, 17 Jan 2017 16:10:31 GMT

Either of tables had more than one distinct value, so you need to add more fields to your concatenated composite key.

eespiritu — Tue, 17 Jan 2017 16:11:26 GMT

Try to use:

AutoNumberHash128(field1 & '|' & field1 & '|' & datefield1 & '|' & datefield12) as Key