Solved
Loop through CSV file before sending Email
Hi All,
I have a requirement where I receive a CSV file containing Owner Email, Id and other details as column.
I want to send an email to the people in the “Owner Email” column of the CSV. But i...
SL12345 - You can also use the Pipeline Execute snap and set the Batch Size value to your desired number of records in the target. Create a child pipeline that is just a CSV Formatter and File Writer snap and call that child in your Pipeline Execute.
Basically, this passes the number of records specified in the Batch Size property to an instance of the child pipeline which can create a file of those records and finish, then the parent will start a new child with the next "batch" of records, and will keep iterating until all input records are consumed. Simple data chunking of your original file.
Hope this helps!
