Auto-map allows you to use Celigo Ora prompts to populate source and destination field mappings. Auto-map applies to mappings that use string, number, boolean, array, object, object arrays, and input fields. You must have at least one row with a value in a destination field to auto-map with Celigo Ora.
Note
-
This feature only applies to Transformation 2.0.
-
To auto-populate mappings, you must enable Celigo Ora in your integrator.io account. Click the avatar in the upper right corner of integrator.io, click My Profile, and check Ora.
You can auto-transform all input fields within the provided data using a prompt through Celigo Ora.
|
Before |
Result |
|---|---|
|
Celigo Ora prompt: I need to auto-transform all fields |
|
|
|
|
Auto-transform doesn’t overwrite input field values that have already been entered manually. For example, if the input fields already have the values: studentName, and studentAge and you enter the prompt, “I need to auto-transform all fields.” Auto-transform will preserve the manually entered fields and only add field mappings for the remaining input fields.
|
Before |
Result |
|---|---|
|
Celigo Ora prompt: I need to auto-transform all fields |
|
|
|
|
For more targeted mapping, you can provide the exact names of one or more required fields in your prompt and auto-map only those fields. Use serial commas in plain English to separate each field name in your prompt.
|
Before |
Result |
|---|---|
|
Celigo Ora prompt: I need to auto transform studentName, studentAge, and grades |
|
|
|
|