Question

3
Replies
305
Views
Close popover
Sean Bailey (SeanB897)
Nationwide Building Society

Nationwide Building Society
GB
SeanB897 Member since 2017 24 posts
Nationwide Building Society
Posted: February 20, 2020
Last activity: February 25, 2020
Closed
Solved

Loop through Lookup Table Field Members Extract into list loop

An example of the process I am trying to carry out:

HTML Table :

HTML Table

When text is extracted from the above table it appears as one column: Properties text = *Applicant Miss Nikita Collier*

I wish to then loop through my lookup table headings: 

Members

if the one of the lookup table members is found in the data extracted i.e.

                       StringUtils.Contain()

                       String Value = "Applicant Miss Nikita Collier"

                       Seek String = "{Applicant}" *List loop item iteration* 

 if Boolean returns true then replace "Applicant" with "" 

Finally update "Applicant" member within the lookup table to add record "Miss Nikita Collier"

Screen shot of proposed automation flow below:

Automation Flow

I would like to know whether it is possible to loop through the field members of a lookup table which would enable me to "SeekString" as per automation flow and if possible how I would update the correct field member second highlighted mark. 

Any alternative solutions would be much appreciated if this can be achieved in a different way. 

 

 

 

Pega Robotic Process Automation 8.0 Robotic Process Automation Financial Services Robotics System Architect
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.