Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Accidentally deleted table from Model View

Hi,    I wanted to delete a certain relationship between two tables but instead a complete table was deleted. I marked the relation with the mouse and used the "delete key" to remove it . I see no ...
General Comment
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    You are correct about the behaviour, if you want to delete the relationship you need to rigth click the relationship.

     

    Also be sure to read the pop up menu that confirms what you are deleting. 

     

    For sure you also do this but I always do a save before doing a change in a relationship or delete a table, that way if I do any mistake I can just close and reopen the file.

     

    Maybe you can post an idea on the ideas part of the forum to get the relationship selected when you click and not the table.

Cyborg's avatar
Cyborg
New Member
3 years ago

If you delete table(s) accidently, you can recover them by adding file via Get Data and then selecting just those sheets from the workbook that were deleted. Go to Transform Data and make all the necessary changes that you'd like to make. Under Model tab, you'll see the recovered sheet(s), linked to other sheets. Hope this helps!