Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,088
Community Members
 
Community Events
165
Community Groups

Insights bad import with concatinator

I am having a trouble while importing objects from CSV with concatinator. I want to import two lists that are referecend to each other, Addresses (Adresas) and Containters (Konteinerio Nr.)

I am using double pipe '||' concatinator, but doesn't seem like working, because values are put together as one long string into Container object name but should be separate values, separate objects.

I guess I might be wrong about how I am importing data, please advise me.

csv configuration.pnghow values are imported.pngcontainers import mapping.jpgaddresses import mapping.jpgcsv example.pngimport errors.png

 

1 answer

1 accepted

2 votes
Answer accepted
Andrea Atlassian Team Jun 23, 2022

Hi @Ignas Selvestravicius

The concatenator you specified is used when you want to join multiple columns in your CSV into one attribute in Insight. Instead, it looks like you want the opposite, to split one column in your CSV into multiple values in Insight. Is that correct?

If so, you don't need to specify a concatenator.

Instead, you need to update your IQL to the following:

"Priskirti  konteineriai" IN (${Priskirti  konteineriai${0}})

The documentation for this can be found here: https://support.atlassian.com/jira-service-management-cloud/docs/create-attributes-and-references-from-your-data/

 

If you want to create multiple references from a single field in your data source, use double pipes “||” (CSV or JSON format) or a comma “,” (JSON format only) to separate multiple values.

..

If you are mapping multiple references from the data, enter Label IN (${Locator${0}}) where Locator is replaced by the name of the Locator.


I hope this helps to solve your problem!

 

Best,

Andrea

thank you for advising me :)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

288 views 0 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you