Function reference Extract column values from the session log for use in re-migration setups. Use this function in column assignment transformations when re-migrating files based on the database view migrated_files. ExtractMetadataColumn( string , string , string )
| Argument | Description |
|---|---|
| Session Log Data | The column or variable holding the session log data. If used in direct conjunction with For-Each on the database view migrated_files the this argument would be the column varible [<#result_message>] |
| Column Name | The name of the column for which you want to retrieve the data value. SharePoint: Notice that you can specify eighter the column [display name] or the @. |
| Default Value | If the column is not found then return this default value |
Data type: String Returns the data value for the specified column
Example 1
Section titled “Example 1”ExtractMetadataColumn([<#result_message>] , '[CreatedBy]' , '' ) Returns the value assigned to the column [CreatedBy]. if [CreatedBy] was not assinged hence the column is not in the log data then an empty string is returned
Example 2
Section titled “Example 2”ExtractMetadataColumn([<#result_message>] , '[My_Internal_Column_Name]' , 'abc' ) Returns the value assigned to the column [My_Internal_Column_Name]. if [My_Internal_Column_Name] was not assigned hence the column is not in the log data then the default value abc is returned