What is required to perform an automatic data modification that inserts records?

To perform an automatic data modification that inserts records, two worksheets are required. This is because one worksheet typically acts as the source of the data to be inserted, while the second worksheet serves as the target where the new records will be added. The separation of source and target worksheets helps to clearly structure the data flows and maintain organization within the data modification process.

Using two worksheets allows for greater flexibility in managing the data, as it facilitates validation and the ability to manipulate the source data independently of the target data. This setup enhances the data integration process in tools like Kinaxis RapidResponse, providing a more streamlined and accurate method for handling data modifications, particularly for tasks like inserting large volumes of records efficiently.