Need Easier Way to Include CSV Column Headings
Posted: Thu Oct 15, 2015 3:37 pm
This is the most common problem I have with GoAnywhere. I need to extract data from an iSeries file, output the data to a CSV, but the recipient requries a column heading record, with their specific column headings, according to their provided specifications.
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.
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.