Transfer data from one table to another

[Shiva Kumar8]

Hi,

I'm having an issue here , we had a requirement where we created a custom table and moved all assessment instances into the custom table but the issue is the "View User's Response" UI action not showing the responses in the Custom table, is there a way I can make this work.

[Community Alums]

Hi @Shiva Kumar ,

You can move it with update set. but this will only have skeleton of table i.e columns and field, but data will not be copied.to copy data take unload of data through xml. similarly, you can have xml of table and transfer it from instance to instance.

If your table is already created without any update set then you can export the table and its field as XML format and import it in different instance. If you have related fields on this table, then those will cause problems for sure, as the related data will not be in the other instance. and i dont think there is any way to do it also as you cant just move all the data, it would be as good as a clone.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi Shiva,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Shiva Kumar8]

@Ankur Bawiskar any help on this?