Forum Discussion

RoyB's avatar
RoyB
New Contributor III
4 years ago

Exporting text file with CSV formatting, but with different numbers of fields

I’m working on a pipeline that needs to create and send a text file to a third party That text file contains rows formatted in the same was as a csv file The file contains a header row, then the ...
csv
mapper
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @RoyB,

I have very similar case like yours at the moment, and what am I doing is creating the CSV format on my own, and than I’m using the CSV formatter just to combine the rows and create the output to be ready for writing. Explanation:

Use a mapper to create the CSV format by using the following expression:

$.values().join(',')

With this you’ll end up with one record which is actually one row in the csv file. You can easily keep the sorting field, sort the lines after this, and than just remove them at the end.