Make a combination of columns unique in Primentra
One value may repeat; the combination may not. Build a Combination unique rule over two columns, watch it refuse a duplicate pair, and see why no single cell is at fault.
⏱ Chapters:
0:00 Intro
0:14 Unique together, not on their own
0:33 Build it
1:18 Severity and message
1:37 Test before saving
1:58 The pair it found
2:41 Example one — the same number, another region
3:02 Example two — the same number, the same region
3:21 Example three — the other column moves
3:43 Empty halves
4:00 Three columns
4:25 What you can do now
📘 Read the guide: https://primentra.com/docs/business-r...
🚀 Try Primentra free: https://primentra.com/download
📚 Documentation: https://primentra.com/docs
Primentra is on-premises master data management on SQL Server: models, entities, hierarchies, approvals, staging and a REST API, without Microsoft MDS.
#Primentra #MasterDataManagement #MDM #SQLServer