i need to create a file through a process. This file always has a header even if my data request is empty.
For the moment, i generate my data file with the option "Generate If Empty" of the template "Action Process INTEGRATION File (FileExport)".
And then, i put a line with a "Write a file" in append mode "Before" ....
The "INTEGRATION File (FileExport)" template also has a "Generate Header" option (at the same location as "Generate if Empty").
Please check that it is enabled.
If it is missing in your template, please download the latest template version.
I hope this helps
The headers are taken from the JDBC result set, they should appear in the result file.
Please send a ticket to the support team.
Edit : attach to the ticket a few screenshot, so that they have enough information : the mapping, the file metadata, the source tables, the query executed by the SQLFileExport action...