Property Transfer Step
I have a question with regards to this.
<p383:getSubscriberAgreementListResponse xmlns:p383="http://types.subscriber.svc.lhs.principal.com/SubscriberService_2_1/">
<memberAgreement>
<effectiveDate>2010-01-01</effectiveDate>
<expiryDate>9999-12-31</expiryDate>
<agreementID>993669000826914</agreementID>
<productCode>9</productCode>
<productDesignCode>2000066</productDesignCode>
<productSubClassCode>9</productSubClassCode>
<statusCode>1</statusCode>
<cgsStatusCode>1</cgsStatusCode>
<productSubClassDescription>Dental</productSubClassDescription>
<memberGroupID>723764000595644</memberGroupID>
</memberAgreement>
<memberAgreement>
<effectiveDate>2010-01-01</effectiveDate>
<expiryDate>9999-12-31</expiryDate>
<agreementID>503863000158764</agreementID>
<productCode>10</productCode>
<productDesignCode>2000067</productDesignCode>
<productSubClassCode>9</productSubClassCode>
<statusCode>1</statusCode>
<cgsStatusCode>1</cgsStatusCode>
<productSubClassDescription>Dental</productSubClassDescription>
<memberGroupID>723764000595644</memberGroupID>
</memberAgreement>
</p383:getSubscriberAgreementListResponse>
As you can see I have two memberGroupID fields(See Above) and I only care about the first one because its product code is equal to 9. When I setup the property transfer step(See Attachement) I selected the one I wanted and it hard coded a [1] saying grab that specific occurrence. Is there a way I can add logic in the property transfer step to look at product code and when it is equal to 9 grab the corresponding memberGroupID? Note: I know that this reponse has teh same member group id however there are instances where they are different!
<p383:getSubscriberAgreementListResponse xmlns:p383="http://types.subscriber.svc.lhs.principal.com/SubscriberService_2_1/">
<memberAgreement>
<effectiveDate>2010-01-01</effectiveDate>
<expiryDate>9999-12-31</expiryDate>
<agreementID>993669000826914</agreementID>
<productCode>9</productCode>
<productDesignCode>2000066</productDesignCode>
<productSubClassCode>9</productSubClassCode>
<statusCode>1</statusCode>
<cgsStatusCode>1</cgsStatusCode>
<productSubClassDescription>Dental</productSubClassDescription>
<memberGroupID>723764000595644</memberGroupID>
</memberAgreement>
<memberAgreement>
<effectiveDate>2010-01-01</effectiveDate>
<expiryDate>9999-12-31</expiryDate>
<agreementID>503863000158764</agreementID>
<productCode>10</productCode>
<productDesignCode>2000067</productDesignCode>
<productSubClassCode>9</productSubClassCode>
<statusCode>1</statusCode>
<cgsStatusCode>1</cgsStatusCode>
<productSubClassDescription>Dental</productSubClassDescription>
<memberGroupID>723764000595644</memberGroupID>
</memberAgreement>
</p383:getSubscriberAgreementListResponse>
As you can see I have two memberGroupID fields(See Above) and I only care about the first one because its product code is equal to 9. When I setup the property transfer step(See Attachement) I selected the one I wanted and it hard coded a [1] saying grab that specific occurrence. Is there a way I can add logic in the property transfer step to look at product code and when it is equal to 9 grab the corresponding memberGroupID? Note: I know that this reponse has teh same member group id however there are instances where they are different!
