• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 2842 views
  • Users 0 members are here
Options
Related
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

siva pemmasani
over 5 years ago

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 over 5 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.