Forum Discussion

Contributor

6 years ago

CSV with header, detail, and trailer records on S3

I need to create a pipe delimited text file. The file needs to have a single header type record row with two columns, infinite number of detail record rows, and a single trailer type record row with ...

Employee

6 years ago

Here is another solution that uses Gate and JSON Generator to handle multiple records from any of the three incoming streams. Note that it does expect each of the incoming documents to have a single field “record” containing the full record data.

Header_Body_Footer_to_File.slp (12.3 KB)

Header_Body_Footer_to_File.slp12 KB

heidi_andrew

Contributor

3 years ago

i cannot get this to work as the body of the file is fixed format. A mapper snap does not work between the union and file writer either. Nothing is coming out at all.

Forum Discussion

CSV with header, detail, and trailer records on S3

Recent Discussions

Pagination and nextCursor in header

How to get filename from file reader

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM