In the column [Metadata Mapping] you can map source columns to destination columns. You may use Mapping lists and Calculations
The name syntax for the columns is a follows:
- [My column display name]
- [{ColumnInternalName}]
*Direct mapping:
[My destination column] = [The source column 1]
[{_x006d_info}] = [The source column 2]
Notice the syntax [{ }] for referencing columns by internal name
*Calculated: (Expression documentation)
[MyDestCol] = <exp>If([MyCol]='abc', [MyCol1] + Left([MyCol2],3), 'xyz')</exp>
If the value in the source column [MyCol] is equal to ‘abc’ then the calculation will concatenate the value in the column [MyCol1] with the first 3 characters of the column [MyCol2] and if not the value ‘xyz’ is assigned.
*Default value for column types Managed Metadata, Content-Type, Lookup
[MyDestManagedMetadataCol] = [MyCol];#Default:abc
If the value in the source column [MyCol] does not resolve to a valid Term in the Term Store then the value ‘abc’ is assigned.
*Mapping lists to replace one value with another
[MyDestCol] = [MyCol]|Mapping1
The value in [MyCol] is mapped to a different value based on the From and To columns in the mapping list named “Mapping1”.
There are 3 mapping lists defined Mapping1-3 and they are managed as a standard list in SharePoint.
*Mapping lists continued: Managed Metadata, Content-Type, Lookup:
When a value is unmapped and does not resolve to a valid Term in the Term Store a new item is automatically added to the mapping list with the value <NotFound> in the [To] column of the mapping list. Thereby enabling you to identify unmatched values and supply the [To] value for those items.
Using a Default value combined with a mapping list:
[MyDestCol] = [MyCol]:#Default:123|Mapping1
In the above, the value in [MyCol] is mapped using the mapping list Mapping1. If the mapped value does not resolve then the default value is used. If there is no mapping match and the source value does not resolve then the default value is used.
Last modified:
20 December 2024
