RE: Make Composite Key of two Oracle fields into a lotus notes field Daniel W Heichel 30.Jul.12 11:40 PM a Web browser LEI LEI - 6.0All Platforms
You will need to use a script in conjunction with LEI. This should be pretty easy to do.
1. First, move your data from Oracle into LEI using your choice of activity. (Direct Transfer would be ideal here, Replication would also work). You will now have two fields in Notes, "First Name" and "Last Name".
(This step is necessary because LEI must map field-to-field).
2. Now, write a script that simply pulls the value of these two fields, joins them, and puts their result into a third field called "Full Name".
3. The final step is to automate it! You can create an LEI Scripted Activity, which will launch the script mentioned in step 2. Now you can set this activity as a dependant of the activity you created in step 1.
Now when you run the activity, it will pull the two fields into Notes, then automatically launch the script that will combine them into one field with the full name.
Return to top
. . RE: Make Composite Key of two Oracl... (Daniel W Heiche... 30.Jul.12)
Print this page
