Use this feature to automatically move a sub-set of your data into a new data table
Table of contents
Create an Extract Records of Interest query
Go to Admin > Automation > Extract records of interest
- Click on the + sign to create a new job.
- Give it a name and Confirm.
- Select the source data structure where all your data is saved.
- Click on Edit condition, and use the smart filter view to set the condition(s) for data extraction.
- Select the Target data structure, where you wish to save the extracted data.
- Map the fields between the source and the target. You can choose all or some of the fields, depending on your needs. Make sure to map fields of the same type.
- You will be redirected to the list of Extract Records of Interest jobs.
- Open the menu of the job you have created, and click on Run Once.
- Follow the progress of the job under View job status. For more details, check this page.
.
✅ The records will remain in the source data table. Only a copy will be moved to the target table.
💡 Bonus: You can enable Ignore duplicates on a specific field. In this case, only one of the records where duplication is found will be extracted.
Menu Actions
In the menu of each job, you will find the following actions:
- Edit: Edit any configuration of an existing job.
- Run Once: Run the automation job to get the desired results.
- History: View the actions performed on this job with the details of the user and the date.
- Archive: Move this job to the archive when it's no longer needed.
Table Actions
On top of the Extract Records of Interest jobs, you will find the following actions:
- + sign: To add a new job.
- Select Page length: Define how many jobs you want to see on one page. The default is 25.
- Refresh: to refresh the list (the list will auto-refresh unless you have this section opened in 2 tabs/windows/users, and you are applying changes on the other one).
- Show archived: When enabled, the archived jobs will be displayed on the same list.