Move selected records from table a to table b

Move selected records from one database table to another.

Overview

The issue is transferring specific records between tables without losing data.
First, read the selected records from the source table using a read data action with a condition. Then, loop through the results and save each record to the target table. Optionally, delete the original records from the source table after the move is complete.

Answered
Connectivity v6
sa samir1903 16 Apr, 2019
how can i move selected records from table a to table b
he healyhatman 17 Apr, 2019
Answer
Do you want to MOVE them, or COPY them?

Option 2: A read data action for table A with id IN {data:selected_entries} , and a loop with data source set to {var:read_data} or whatever your read data is called, with a save data action in the loop pointing to table B.

Option 1: Do everything above, and then delete the selected records from table A
This topic is locked and no more replies can be posted.