Copy Record from 1 Table to another Table record


I need to be able to take a very large file and split it into multiple not so large files based on criteria for each record in the original table. I need to write a record from mytable_1 to mytable_2 a record at a time. Using Constant Value or Expression actions do not seem to have a method to write the record. Not sure how I would use the Modify Table for this?



Hi Austin,
If you use Modify Table, you need to insert the values manually, so it is not appropriate for your case. Maybe, you could post you zipped recording here so we could have a closer look?
If your file contains sensitive information, you can create a small sample excel file with test data.

Thank you.