Using Filemaker to Format CSV Order data for a Import into Business System
I am trying to use filemaker to arrange incoming order data from a cvs file. I need to change the cvs file from a one line per order spreed sheet to a two line per order spreadsheet.
I need to have the header information one one line and the item information on the line underneath. The first column indicates what the record will be. The Header portion of the data starts with HDR in the first row and the line item information will start with ITM in the first column directy under the HDR info.
The CSV file has all of the data on a single excel row. I am bringing that data into filemaker and splitting it up into two tables. 1. Hear table and 2. line item data. I am connecting them with a po#
How can I export the data so I get a header row first then a item detail row? Any suggestions would be great.