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]

In that case, you should not create new table ( as child ) using the extends instead create a standalone table and dump the data from one table to other. 

not sure, what's your overall planning/purpose to keep local achieve copy, as you already have achieve rules means data lifecycle already completed and no update required.

-Thanks

[cpinedatx94]

But i need the same fields as the original Table. Thats why i am make a extension. 

I have MANY fields that i need to keep. If i do a standalone table i will have to recreate these fields and will run into mapping problems when it comes time to import the data.

By extending the table im able to copy all the fields exactly. then i can just plug in the data. I just dont want the two tables combined. 

Is there a way to unmerge or remove a extension from a table to make it a standalone?

[AshishKM]

You can try on PDI but after you remove the extend option all the common column ( from parent table ) will not visible on child table .. because that table no more child of that parent table that will impact the data import on said child table.

if you read about “how this extends table” works you will understand more on it, when we extend table without using extend model, then there is single table at database side which keep the data for parent & child table. It’s logical separation on application side but single table at database side.

Example : Task table , other table like incident , change , ritm , problem etc. are extending logically but database has only one Task table.

I would suggest to follow standard ootb  archive practice. 

-Thanks

[AshishKM]

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

[cpinedatx94]

No i just want to learn how to make a copy of a table. Thats all i want. A copy of a table. no extras frills. No this or that. I just want a straight up copy up of a table. Is there anything i can. Or is this just impossible with service now. If its impossible with doing some crazy scripting crazy things please let me know.