Create Opportunity and Opportunity product
I have source table consists multiple product records. My requirement is to create a Opportunity with Opportunity Products using Scribe Insight work bench.
Here is the source table data:
I have added two target steps: Step 1 is for Opportunity Insert & Step 2 is Opportunity Product Insert. I added skip if repeated on Step 1 for source fields of Opp#, Account#, Contact#. It is working fine and creating only one Opportunity. But the Step 2 is doing nothing. It supposed to add three Opportunity Products to the Opportunity just created.
I am not able to catch the newly created Opportunity GUID from Step 1 and pass it to Step 2 so that it will get added.
Can anyone help me on this? Thanks in advance.