Forum Discussion

Naomig2088's avatar
Naomig2088
Icon for Helper II rankHelper II
2 years ago

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...
Need Help
halfglassdarkly's avatar
halfglassdarkly
Icon for Responsive Resident rankResponsive Resident
2 years ago

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.