Copy Duplicate list of results from two page lists

User Experience
, ,
1

I want to copy list of results to one-page list from two page lists

need expressions and activity steps

2

@vinodkumarv1966

Hi,

could you please expand your question.

You want to copy all duplicate results from 2 page lists to one page list right?

Or else

Want copy all results from two pagelists to one pagelist ?

3

@vinodkumarv1966 For copying the contents of two pagelists and removing duplicates, you could look at:

  1. For merging multiple pagelists into one, you could use Page-Merge-Into, see: https://community.pega.com/sites/default/files/help_v72/methods/page-merge-into/page-merge-into.
  2. For removing duplicates from a pagelist, take a look at the pyRemoveDuplicatesFromPagelist activity

Additionally, you can use a function like @countInPageList to check for duplicates if you’re looping through a list in an activty or data transform.

4

@Charan Narra

lest say 5 matching duplicate records in 2 page lists that 5 page results should copy in to one page list with 5 results

5

@BasG0629

i want to compare 2 page list having with 10 results for each page that 2 page list having 5 comon page results that 5 pages should come in to one page list

6

@vinodkumarv1966

If I have understood your requirement clearly, you have 2 page lists, say list1 and list2 and you want to copy data from list2 to list1 except the duplicate ones.

  1. Create a when rule which returns true if 2 records are considered as duplicate. Say DuplicateFound

  2. loop over list2

2.1 use this function in your first embedded step when @IsInPageListWhen [pass list1 as pagelist and DuplicateFound as when]

2.2 if above function returns true, do not copy , otherwise use simply page-copy to append record in list1.

7

@AvikMitra Seems like an elegant solution!

8

@AvikMitra

what when condition to take in when rule to check duplicates

9

@vinodkumarv1966

lets consider list_id is the property in both the lists list1 and list2 which holds the unique value to determine duplicate.

here is the step I mentioned before:

  1. loop over list2

set param.list_id = .list_id [here list_id is of 2nd page list]

2.1 use this function in your first embedded step when @IsInPageListWhen [pass list1 as pagelist and DuplicateFound as when]

in DuplicateFound when rule compare, param.list_id = .list_id [here .list_id is of list1 page list]

2.2 if above function returns true, do not copy , otherwise use simply page-copy to append record in list1.

now if you need more than one field to determine whether a record is duplicate or not, keep on adding them in the when rule as AND/OR condition, whatever suits your requirement.