Forum Discussion
Refresh error duplicate values in the table
Hi, I'm experiencing a refresh error that states that there are duplicate values in a column in the data table. "Column 'StartofMonthLeaveDate' in Table 'Leavers for Turnover (2)' contains a duplic...
You either need to change the cardinality of the table relationship from many to one to many to many (but many to many relationship isn't usually a good idea) or create a new key in both tables that concatenates your date and department values and remap the relationship between the tables using the new key.