Map/concatenate multiple text properties into a single property
We would like that, in PowerShell, we could have the ability to map multiple properties to a single property.
At the moment, it seems that this is possible only with certain types of fields.
"3) Advanced scenario – Multiple columns to a single column
Since Sharegate 2.9, any destination column that supports the ‘multi-values’ (Lookup, Choice, People, Managed Metadata) option will allow more than one column to be mapped to it"
https://sharegate.com/blog/sharepoint-merge-remap-multiple-columns-to-a-single-column
So if we have a simple scenario such as:
Property A (text)
Property B (text)
We cannot map them to a
Property C (text)
this is only allowed if Property C is an MMS column or other supported type.
it would be interesting to be able to perform such a mapping , for example:
Property A value: "dog"
Property B value: "cat"
examples:
Property C value: "dog, cat", "dog; cat", "dog cat", "dog [newline] cat".
in short, we would have the ability to pick a delimiter and concatenate the values of multiple text properties into a single text property.
thank you
