integrator.io helps to connect business application and transfer data between them. Field mapping defines how the data from the source / lookup will import into destination.
There are 4 types of Field Mappings
- Standard/Simple
- Hard-Coded
- Lookup
- Multi Field
Standard
The direct transfer of a field from export to import is called standard field mapping. i.e, the source is imported word for word to the field in the destination. It is a simple method of field mapping.
Hard-Coded
The hard-coded field mapping is used when a field in the destination will always have the same value across all records. For example, if an active check box will always be checked, then we can use hard-coded field mapping.
Lookup
When the value from the source field needs to be translated into a different value in the destination then lookup field mapping can be used. It translate the field value from the import, or searches to find the correct field value.
Multi-Field
It allows you to manipulate the data from one or multiple fields before importing it into a destination field. This mapping can combine fields into the import or they use expressions to transform data for the import.