This discussion is archived
8 Replies Latest reply: May 19, 2013 4:03 PM by frank.hampshire RSS

OPA Batch Processor: multiple fields as primary-key

749238 Newbie
Currently Being Moderated
In the configuration file for the OPA Batch Processor you have to define the primary key for all the csv-input-files. In our situation the primary key of some tables is a combination of some fields. For example we have a table "household" and a table "person". In the table "person" the primary key is a combination of the householdnumber and the personnumber (which is a serial number within the household).

When I try to use a combination of fields as primary-key a get an error regarding the amount of fields in the csv. Is it a point of principle that a primary-field only can contain 1 field?

Cheers, Pierre


  • Correct Answers - 10 points
  • Helpful Answers - 5 points