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 Profile, and check the Enable Ora box.
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 |
|
|
|
|