Extended table keeps merging with Parent table

[cpinedatx94]

I created a new table which was a extension of another table in order to copy over all the fields. Since this table was going to be a copy of the parent.

I went ahead and exported the parent table to xls format and reloaded the data into the the new table. via import and transform. I went ahead and check my new table and they all imported correctly. But now when i check the old table it appears IT ALSO CONTAINS the new loaded data. (so basically duplicate records.) What could be causing this. Could someone please assist me?

[AshishKM]

Hi @cpinedatx94 , 

In the case of parent & child mapping, the parent table already ( default ) showing the child table data which can be identified via the class column. 

If you are testing something, we are not sure but why we need a child table there should be some logical purpose  addressing some business requirement.

When you created a new table along with extension of some table ( parent table ), it means you want to some kind of data segregation under the same hierarchy, you should not export from parent and import to child table instead just change the class value as child table. 

Now you have duplicate data, you can delete the duplicate or mark some duplicate flag (like operation status:-duplicate).

Let me know if you have more question on it.

-Thanks,
AshishKMishra

[cpinedatx94]

If i delete it the duplicate from the parent will it now delete it from the new child table?

[AshishKM]

@cpinedatx94 , hope you got the desire answer here, please accept solution and close this thread. 

[cpinedatx94]

my goal was to create a direct copy of the table for record keeping. It was going to be a archive. So we could then make changes to the original without losing the old records.