Forum Discussion

duncfair's avatar
duncfair
Icon for Helper IV rankHelper IV
5 years ago
Solved

Refresh error message demonstrably wrong - how to fix?

Data source error: Column '0-30%' in Table 'vw_TargetTool_Hist_2021' contains a duplicate value '<pii>68</pii>' and this is not allowed for columns on the one side of a many-to-one relationship or fo...
Need Help
  • timg's avatar
    timg
    5 years ago

    Hi duncfair,

    Could you check if the relationship cardinality between this table and other tables is set correctly? If these are not set correctly it could also cause a duplicate error, so perhaps that's the culprit.

    Regards,

    Tim

timg's avatar
timg
Icon for Solution Sage rankSolution Sage
5 years ago

Hi duncfair,

Could you check if the relationship cardinality between this table and other tables is set correctly? If these are not set correctly it could also cause a duplicate error, so perhaps that's the culprit.

Regards,

Tim

duncfair's avatar
duncfair
Icon for Helper IV rankHelper IV
5 years ago

Hi Tim,

 

Thanks! I was not the original creator of this report (I'm the backend data guy) and the issue was an auto-created relationship that didn't make any sense. Changing that resolved the error.