Sharing some of my thoughts. I didn't get a chance to implement similar requirement. So you can wait for any better suggestions also.
Option 1 - You can try using removeDuplicatesFromList and/or pyRemoveDuplicatesFromPagelist and see if it helps to remove duplicate records from RD result based on Business Analyst column.
Option 2 - If you are already looping through RD results, add BA values to a new page list. Before adding check IsInPageList. Since we have this check this list won't have duplicates. Get BAs from this new page list to get email address.
Option 3 - Create another RD with same filter but have only Business Analyst column in result. Select Remove duplicate rows check box in RD. Use records from this RD result to get BA for getting email.
Option 4 - Split the email string using whatComesBeforeFirst and whatComesAfterFirst functions and copy each email to a page list. Check IsInPageList before adding to PageList. Loop through this page list to create email string again.
Posted: 2 years ago
Posted: 12 Jun 2020 10:00 EDT
Bhargav Putumbaka (BhargavP2852)