Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
- Posts: 8
- Joined: Fri Aug 10, 2012 11:55 am
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.
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
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
Return to “Community Forum”