How to clone a table with records

[cpinedatx94]

I want to create a exact duplicate of a current table and its records. How can i about doing this? Is there any way of doing this wayout scripting? Like a button that just lets me make a copy? Or do i need to write a script?

[cpinedatx94]

Its also not letting me extend from the table i want to extend from. its only letting me extend base tables

[AshishKM]

The parent table should be declare extensible first.

[Ashir Waheed]

Hi @cpinedatx94 

Your parent table( the one to be cloned) need to extendable first to enable extend

[cpinedatx94]

Thanks for the reply. I went ahead and created the table with your information above.

Im now trying to find the new table to load the Excel sheet into but it doesnt appear in here.

[Ashir Waheed]

Hi @cpinedatx94 that the data import here you will find all the temporary table that we can use to store the data before transforming.

1. Go to List View of your table that you want to clone and get the excel data or XML.

2. Now go to the table that you created new which should be extended from parent (clone table)

3. Click on the Import

4. Upload the excel data that you exported.

5. Once the data is loaded, Preview the data.

6. Scroll down at the bottom and Click Complete Import.

7. You will now be able to see data in Child table/ new table

Regards,

Ashir Waheed