Forum Discussion

gg433's avatar
gg433
New Contributor III
6 years ago

Insert 2 rows at the top of a csv file

I’m querying a database that’s returning 2 columns, id and color. My requirement is to save this data to a csv file. The first 2 rows of the csv file must have these values, row1 “&CID=555573”, row2 “&SUBID=266690”. The data should have no header row. This is what the csv file should end up looking like if I brought back 2 records. How do I accomplish the hard-coded header rows 1 and 2? The csv formatter doesn’t seem to have the configs I need, I looked into the Document to Binary snap, but cannot figure it out.