1 Reply Latest reply on Sep 2, 2014 8:39 AM by philmodjunk

    csv import

    CharlesSipes

      Title

      csv import

      Post

      I have a .csv file with a list of records like PO numbers. Each PO has up to 7 line items. I need to import each separate PO to one record with repeating fields for the item numbers. How can I setup to match records to get the import to work or how can I create a second table to make that work?

        • 1. Re: csv import
          philmodjunk

          Repeating fields are not a good choice for LineItem data in a relational database such as FileMaker. You will have much more flexible control of your data if you import them into a related table with one record for each line item. And this can be done from your csv file. Whether you take that advice or not, we'd need to know how the lineitems are arranged in your CSV file. Is each lineitem in a different column or do you have multiple rows for one PO, with one lineitem to a row?