cancel
Showing results for 
Search instead for 
Did you mean: 

Separate file per record

jason_steindorf
New Contributor III

How would you create a separate file per record instead of the standard file with multiple records

6 REPLIES 6

Thanks @darshthakkar , i got it working

koryknick
Employee
Employee

@jason.steindorf - Thanks for the clarification.

Here is a small example pipeline that I believe will do what you are looking for without the requirement for Pipeline Execute or Group By N snaps. Basically, I’m manually formatting the data values as CSV using the Object.values() method to get the array of values, then joining those values using the Array.join() method to concatenate the values into a string. This is sent to the $content Target Path, and I’m setting the content-type and providing a filename in the binary header properties for the File Writer. The Mapper is using a “binary” output view to feed into the File Writer.

So there are several tricks in here, but it’s very low-weight and produces one output file per document.
Community 13446 - Multi CSV Output_2022_09_20.slp (5.6 KB)