Example
Given the following CSV file (The pink color is added to illustrate meta values. They are not included in the data file) example1.csv
File1 - Office
Meta information | |||
CSV header row | ColumnName | ColumnCity | Zip Code |
Data row | ACME studios | Stockholm | 12345 |
Data row | Rockets "r" us | Stockholm | 54321 |
The Insight Attribute Configuration
The same file (File 1) is mapped to two object types Office and Company
This illustrate what we want the data in Insight to be after the import of the file in the Office object type.
Office | Type | Office 1 | Office 2 |
---|---|---|---|
Name | String | Stockholm | Stockholm |
Zip Code | String | 12345 | 54321 |
The import configuration for the Office object type
This shows the result we want to have in Insight after the import in the Company object type
Company | Type | Company 1 | Company 2 |
---|---|---|---|
Name | String | ACME studios | Rockets "r" us |
Office | Object reference (to office) | Office 1 | Office 2 |
In order to create the reference to "Object 1" and "Object 2" we have to reference the objects based on multiple attributes in the form of an IQL. The IQL will like
|
Where the placeholders are referenced from the data locators as specified in the configuration. The IQL will be configured as the attribute configuration for the Companys Office attribute configuration i.e. it will only be available if the attribute type is of object type.
The import configuration for the Company object type
A sample of the result
There is also a video available showing an example of how to set this up: