My question is related to the files generated using Open Hub. I understand Open Hub generates two file (header and data) for the flat file output.
- How can we merge these two files and create one file with the header and data?
- I believe I need to write a code to merge these file, what's the best place to write the code. I mean I don't see any thing within Open Hub that allows to write code for the output file.
- Also, I need to generate one file with header and data, also I need to add the date time stamp to the file name. Is there any way we can do it?
- I also need to have the EOF line at the end of the flat file (CSV format). If I know the code for merging the file and where to write the code, I believe I can extend it to insert additional record for the EOF.
I appreciate any help on this.