[jira] [Created] (NIFI-10996) CSV output with header - but always, even for 0 record flowfiles

["Josef Zahner (Jira)" <ji...@apache.org>]

Josef Zahner created NIFI-10996:
-----------------------------------

             Summary: CSV output with header - but always, even for 0 record flowfiles
                 Key: NIFI-10996
                 URL: https://issues.apache.org/jira/browse/NIFI-10996
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Core Framework
    Affects Versions: 1.19.1
            Reporter: Josef Zahner
         Attachments: NiFi_CSV_header_true.png

We use a “ConvertRecord” processor where we convert an AVRO to a CSV. For that *CSV* output we would like to have the {*}header enabled{*}, so we tried to set “{{{}Include Header Line – true{}}}” for the Controller Service of the CSVRecordSetWriter. The issue is, *if we have zero records, the header doesn’t show up* (but it was there of course in the AVRO file). We need to have it as the columns are important for us, even if we have 0 records.

At the moment we solve it with an extra ExecuteScript processor just before the ConvertRecord, there we add always an extra record with the header lines as string. But it feels a bit hacky as the record.count attribute is 1 record too high (due to the fake header record).

!NiFi_CSV_header_true.png!

Comment from [~joewitt] from users mailinglist: _"Makes sense what you're looking for.  Just not sure where this 'concern' would live whether it is in the processors themselves or the controller services for the writers."_

It seems that I'm not alone with that requirement, at least one other person (Jens M. Kofoed) uses a similar workaround.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)