Append Query Error

[Adam_123]

I'm trying to append two queries together. One is from a csv file while the other from an xls worksheet. The data comes up fine in the query editor but when I try to Close & Apple, I get the following error:

Geography
Column 'Column1' in Table 'Geography' contains a duplicate value 'ACSSF' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

The column above just contains data. I haven't defined any relationships or created any models. I'm just trying to append the rows from one query to another.

[az38 · Accepted solution]

Hi @Adam_123 

from simple data models relationships are defined automatically.

So, first remove relationships in report mode then do you appen workaround in Query Editor

[Adam_123]

Thanks a lot @az38 . That worked!