Loop through Lookup Table Field Members Extract into list loop
An example of the process I am trying to carry out:
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:
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:
An example of the process I am trying to carry out:
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:
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:
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.
Accepted Solution
Updated: 25 Feb 2020 7:27 EST
Pegasystems Inc.
US
Here's a method you might use to iterate the column names. I don't think you need to do that though as your column names are going to be static by the very nature of a lookup table (i.e. it can't change it's columns at runtime). It might just be easier to use a Switch to handle specific ones from your HTML table and update the corresponding field in your lookup table. If you want to iterate them though, here's a method that will work. The key is to use the GetTable method from the LookupTable as that returns the underlying DataTable object. From there, you can access the Columns property to get to the collection of columns which you can iterate to get the ColumnName of each one.
Pegasystems Inc.
US
Would you be more specific about what you are doing? You can see the columns as outputs when you call GetRecord. Are you asking to loop through all of the records, or to just get a list of the column headers? I ask because the latter doesn't seem very useful since you'd know the columns already in your setup of the lookup table.
Accepted Solution
Updated: 25 Feb 2020 7:27 EST
Pegasystems Inc.
US
Here's a method you might use to iterate the column names. I don't think you need to do that though as your column names are going to be static by the very nature of a lookup table (i.e. it can't change it's columns at runtime). It might just be easier to use a Switch to handle specific ones from your HTML table and update the corresponding field in your lookup table. If you want to iterate them though, here's a method that will work. The key is to use the GetTable method from the LookupTable as that returns the underlying DataTable object. From there, you can access the Columns property to get to the collection of columns which you can iterate to get the ColumnName of each one.