Import multiple values into single field

[dannica_c]

Hi,

Requesting your advise on importing multiple values into a Single Field.

Trying to import the Roles however some Roles have multiple Department

Department is an Object configured with Unlimited values "cardinality = unlimited"

CVS format:

Role, Department, Department
"Will Call CS OPS Associate", Customer Service, Shipping

[Joseph Chung Yin]

@dannica_c -

As documented by Atlassian -

• To divide multiple values (for the Insight attributes with multiple cardinalities), you can use “||” (2 pipe characters) within the CSV file.

• If you wish to join multiple values into one Insightattribute, you can use a concatenator in the CSV file. The default is a dash symbol “-”. If the data is concatenated with a space, you can enter “/s” in the Concatenation field when creating an import configuration.

Hope this helps.  Here is the actual KB link for your reference - https://support.atlassian.com/jira-service-management-cloud/docs/import-a-csv-file-into-insight/

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[dannica_c]

Hi Joseph,

Tried to import using below details but issue persists. I put IQL: Department=${Department}" and Concatenator is empty. Did I missed anything?

CSV Format:

"Role", "Department"
"Will Call CS Ops Associate", "Customer Service"||"Shipping"

[dannica_c]

I just removed the "quote" then added the || pipe. For the IQL, I used Department IN (${Department${0}})

[Joseph Chung Yin]

So, are you still having issue?  Please advise.

Best, Joseph

[dannica_c]

not anymore, this issue is resolved. thank you! :)

[dannica_c]

Please see attached mapping