This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Need to club two different notes data type fields as one sharepoint column

Hi All,

I have two fields(Site, number) in lotus notes form, site is a text field and number is number field, can you please confirm can we club them in share point as one column using quest tool ? if yes, please guide me how can we do it.

I tried in merging them in site field in SharePoint tab in source Mapping > automapp Names.

Tried with :,+,;, but not working , can you please help how can i proceed.

0 Peter.Mendelsohn over 7 years ago

Hi, there are two ways of doing this:
i) Define a source field of type formula in the Source Definition and add the two fields together (in Notes formula syntax). If they are of different types, you may need an @-Formula for Type conversion (e.g. @Text).
ii) Set the target SharePoint field to "Allow multiple source = true" in the Target Definition. Map both source fields to that target field.

With i) you are more flexible, of course.

Hope this helps.