The Sugar database was customized to include 10 fields on the OPPORTUNITY table called "PERSON1","PERSON2","PERSON3" ......to "PERSON 10"
I would like to import these into a custom SalesLogix table called C_OPPORTUNITY_PERSONS which lets you associate 1 or more persons to an Opportunity.
So essentially each row in the source, could result in up to 10 rows being inserted into the destination.
Further I would like to implement some logic that if PERSON 3 is blank, then that row should not be imported
What would be the best way to accomplish this?
One way I can think of is to setup 10 tasks under the Opportunity job to import each field...but thats a bit painful! :unsure:
I'm sure there's an easier way!
Login or sign up for our forums to connect to the user community.