Loading Multiple Values
· To enter multiple values in a multi-select field, add rows immediately following the initial row and leave all fields in these rows blank except for the key fields and the fields holding the multi-select values.
· For example, the Cost Center field accepts more than one value; to add multiple cost centers you need to specify only the Applicant ID (key field) in the additional rows and a reference ID for each Cost Center:
Spreadsheet |
Applicant |
Applicant |
|
Company |
|
Cost |
|
Region |
|
|
Key |
ID |
Name |
|
|
Center |
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
A01032 |
A01032 |
Julie Bowles |
|
2501.21 |
|
61200 |
|
2503.42 |
|
|
|
|
|
|
|
|
|
|
|
|
|
A01032 |
|
|
|
|
|
61210 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
It is recommended that you use the ID of the object you are loading if it is available. For example, the spreadsheet key for data being loaded for an employee can be the Employee ID.
ROW
IDS
It is recommended that you use the ID (Spreadsheet key) of the main object followed by -1, -2, etc for each child row of data.