Column Mappings

Column mappings defines how a single column from the data source maps to a column in a target table. Each <ColumnMapping>  has both a source and a target. If the destination is a Cinchy table and the target column is a link, then a third attribute becomes available called "linkColumn" which is used to specify the column that should be used to resolve the linked record from the source value. The value of sourceColumn should match name attribute of Source . The value of targetColumn should match that of the target table.
Below is an example of a Column Mapping in the experience followed by the equivalent XML. In the experience, the Source Column attribute is a dropdown of columns configured in the Source Section.
<ColumnMapping
    sourceColumn="string"
    targetColumn="string"
    linkColumn="string"
    >
</ColumnMapping>
Attributes:
sourceColumn
The name of the column in the data source. The name corresponds to the user defined name from the <Column> elements in the schema.
targetColumn
The name of the column in the target table. This would be a table that's already created in Cinchy and defined in the Target.
linkColumn
The name of a column from the linked table. If the target column is a linked column from another table, you may input data based on any of the linked table's columns.
If a source column (of any type) is being synced into a Cinchy Target Table link column, the source column needs to be of dataType="Text", no matter what type it actually is.
Target Destination Config Reference
Target Destination Filter
Last modified 6mo ago