Forum Discussion
Unique column values
Hi Gelain,
How is the real data like? If it likes the sample you posted here, we could create two new table with these formulas. Finally we can create relationship. If not, could you please post a sample?
Customer = FILTER ( 'Table1', LEFT ( 'Table1'[Name], 8 ) = "Customer" )
Supplier = FILTER ( 'Table1', LEFT ( 'Table1'[Name], 8 ) = "Supplier" )
Best Regards!
Dale
Mm recognizable. Can you customize the data source? The easiest way is to add an unique ID/primary key.
Hello,
The data source is SQL Server. Would you have any way to solve this problem?
Thank you.
Do you have the permission to customize the SQL database?
Add a new column to your table: http://www.1keydata.com/sql/alter-table-add-column.htmlAdd (and remove current PK) new PK & Auto incremental to the new column.
https://stackoverflow.com/questions/11794659/add-primary-key-to-existing-table
P.s. Test it first on a local/test SQL database.