concatenated key not unique

[surajap123]

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]

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

[#3]

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

[eespiritu]

Try to use:

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