unable to merge between 2 dataset in Lumira

[Former Member]

Dear Experts,

I'm not able to merge between 2 dataset with same value.

You Can View the screen shot.

Its give me error like the"The selected columns do not constitute a unique key"

For the details, I'm running freehand SQL on a database with SELECT QUERY.

Thanks

[ashutosh_rastogi · Accepted solution]

Hi,

Merge between data sets is a Join between them and hence it follows the same foreign key constraints that are there with any relational table. That is, you can perform join on a column in a table if it referencing a primary/candidate key in the other table. Hence, the values of in the column must be unique in one of the data sets.

However, if your dataset is like that it does not satisfy this constraint and you still want to join two tables then the option you have is to go ahead and use blending feature.

You can get more details here

Regards,

Ashutosh

[balareddykrishnareddy_bal]

Hi,

You can "merge" values only when they are "unique" i.e the value in your field "itemcode" should not repeat.  From the error message on the right bottom of your attachment, "The selected lookup columns do not constitue a unique key" explains this.

Bala.