How can you import multiple values against an object reference?

[Liesa Pugsley]

Using Insight for jira. 

I have an SQL Database import. I have multiple entries for the same ID.
 So I have a User ID and then I have multiple roles for them. For example,
 User ID   Role
 Anne      Assistant
 Anne      Receptionist
 Bob        Gardener

I have an object reference on the object I am importing to a Roles object. How can I get multiple roles to appear in the imported object. If I was performing this as a CSV I would use || (2 pipes) . What do I use for SQL?

[Alexander Sundström]

If the cardinality is correct (i.e more than one, at least 2 in this case), the imports takes care of this by default. 

Try it out and let us know if it works.

Best Regards
Alexander