The options in the Write to CSV task simply allow me to include the column headings, or not. When I do, I get the iSeries field names from the source file. I tried using the Data and Column sub-tasks, and specifying the value they want in the Column Name field, but that clearly does not do what I need.
The workaround that I have used is to create a text file containing the delimited column names they want, and in the GA project, I first copy that file to my output file. Then I use the Write CSV task to append the data to that file, with the column headings option off.
I'd like to know if there is an easier way to do this, and if not, could I suggest an enhancement to the Write CSV task, to be able to put the column heading I want somewhere on the Column sub-task? That would really cut out a lot of additional work.
Currently, that's one option to putting those column headers into your CSV doc. You could also select them from a pre-defined table in the order you want as well. Either works ...
I'm emailing you an enhancement request form. Please fill that out with your request for an update to the product for the CSV Headers.
Lead Solutions Consultant