Need to move the data from one table to another in the same instance

[Community Alums]

Hi All, 

Having a requirement that, need to transfer the data from one table to another. 

The data we are getting the api push in a schedule timeline to instance from teh client environment. and this data need to move to main target table. 

Need suggestion on processing this. 

we tried to created a transform map and try to run through schedule job. But its not working. Any other possible way. 

[Community Alums]

Thanks for the response Ankur, 

Bit confused, when we try to manually create a record in the staging table its automatically runs the attached transform map and creates the record in the target table. 

But when we try to update the same record in the staging table its its not getting update. 

we kept the coalesce on the filed objectguid its a unique value from the client environment. 

Why the other values are not getting update unable to find.

[Robert H]

Hello @Community Alums ,

That is not how Import Sets work. They are a means for pushing data into a staging table, which will then be transformed into the target table. This process happens every time a new Import Set is created and populated with data (e.g through the Import Set API). If you later update data in an old Import Set that was already transformed nothing will happen.

Regards,

Robert

[Community Alums]

Thanks @Robert H 

Thank for the update, Sorry I missed this detail. 

[Robert H]

Hello @Community Alums ,

No worries. Were you able to make the solution work as expected now?

Regards,

Robert

[Ankur Bawiskar]

@Community Alums 

import set logic/transformation runs only when a new insertion happen.

If my response helped please mark it correct and close the thread so that it benefits future readers.