Replication : same source field to multiple target fields Thomas Kennedy 20.May.10 09:51 AM Lotus Notes LEI All ReleasesAll Platforms
If the target is Notes -- and I think it is as you say Field and not column -- you can do this with the Data Transformation tab on the target connection document. This tab has three formulas you can fill in. They are:
A. Formula to execute during select
This formula is executed against documents in the target resultset just after the resultset is fetched. I think that means, before any update or insertion is performed. This is not what you want.
B. Formula to execute prior to insert
This formula is executed on new documents just before they are saved into the target.
C. Formula to execute prior to update
This formula is executed on documents whose data has changed as a result of the activity, just before the document is saved.
You should fill in (A) and (B). The syntax is:
SELECT @All;
some formula here;
In your activity you should map source FIELDA to target FIELDX. Then in your target connection: