Forum Discussion

rboesch's avatar
rboesch
New Member
2 years ago
Solved

Table Updating issue

Hello,   I run a scheduled update for my data from a file that has 8 tabs creating 8 tables from a sharepoint drive. the Source.name file in all is the same vale (the source file) but in one table ...
Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    In your 'Edgerton' table you are using a column as the one side of a one to many relationship. The error is telling you that there are duplicate values in that column, or there are blanks in that column. 

    One path forward is to identify the column in question and add a remove duplicates step to the query. If blanks are your issue you can filter them out prior to updating the model as well. 

    Of course the best practice would be to analyize your table to understand why there are duplicate or blank values and correct the problem at the source.

    Hope this helps.

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
2 years ago

In your 'Edgerton' table you are using a column as the one side of a one to many relationship. The error is telling you that there are duplicate values in that column, or there are blanks in that column. 

One path forward is to identify the column in question and add a remove duplicates step to the query. If blanks are your issue you can filter them out prior to updating the model as well. 

Of course the best practice would be to analyize your table to understand why there are duplicate or blank values and correct the problem at the source.

Hope this helps.