Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Insight IQL: object mapping - two column to one attribute with references

Hi, i have csv file to import with column :

col1,col2, col3, col4

and i have 2 object type

Object type A and Object type B

 In object A(i have only one attribute)

i am joining two data locator(coll1 and col2) to one  attribute called "Name" which is label. i use concentrator "\s" 

In  object B

i have three  attributes:

  1.   col3  >>At1 
  2. col1 col2>> At2 (references to object A. Name)
  3. col4 >> At3

Could you help me , how to write iql object mapping for point 2?

I try Label =(${col1}s\${col2}) but is incorrect

1 answer

It's not totally correct, but the closest I've found to a direct solution is to use: Label startswith ${col1} AND Label endswith ${col2}

This object mapping may fail if you have col1 or col2 values that overlap other values in the csv file.  col1=John / col2=Smith could well match with col1=Johnny / col2=Smith instead of the intended record, for example.

A better solution is to import col1 and col2 as extra attributes into object A so you can match on them directly with the object mapping: col1 = ${col1} AND col2 = ${col2}

In the absence of duplicate col1 + col2 values, it should work well.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

5 mobile apps for Jira Cloud to boost productivity

  It’s very important to have access to the workflow process from anywhere. Especially if you manage the work of others. There is no difference whether you’re out of office, or drive a ca...

260 views 2 5
Read article

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