Question Output File with defined header

Hello,

Is it possible to build a metadata file that contains a defined header ?
This header should be displayed, even though there are no data to extract ...

Thanks for answers

Hi,
Can you please specify where the header should be displayed ?
Are you working with a mapping which reads from a file ? A process which writes to a file ? Which action is being used ?
Thanks

Hello,

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" ....

I assume there is something cleaner to do ....

Thanks

Hello,
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

Hello,

yes i saw it and tryed to use it. But i did not find where indicate the headers ...

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

I found it !
i changed the "Physical Name" of the field in the file descriptor...
Some tests to perform but i think it will answer my need !

Thanks