This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

CSV with header, detail, and trailer records on S3

dwhansen-cbg
Contributor

โ€Ž02-27-2020 12:58 PM

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 three columns.

00|File Type Description
01|Data1|Data2|Data3|Data4|Data5|Data6|Data7|Data8|Data9|Data10
99|1|EOF

I thought I could use multiple CSV parsers + File writer snaps and then just APPEND the detail records and the trailer record, but it looks like the APPEND function isnโ€™t supported on S3. Any ideas on how to accomplish this?

0 Kudos
5 REPLIES 5

koryknick
Employee
Employee

โ€Ž03-06-2023 06:33 AM

Please check to verify that your File Writer snaps are set to Validate & Execute. By default, most โ€œwriterโ€ snaps will be Execute Only.

0 Kudos