Insights bad import with concatinator

Question

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.

Andrea_1cqcdz · Accepted Answer

Hi @Ignas Selvestravičius

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