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

[Arkadiusz Baka]

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

[Craig Haynal]

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.