Question
P3Fusion
IN
Last activity: 9 May 2019 8:17 EDT
Remove Duplicates From MultiSelect Control
Hello,
I have a Multiselect-control to select a multiple value, source as datapage, in my datapage the column "Location" contains values repeated, the values are sourced as same in datapage.
My requirment is that i have to remove the duplicate values from the multiselect control so that user clicks the multiselect he can see only distinct vlaues. can anyoneKnow the solution
Thanks in advance,
***Edited by Moderator: Pallavi to update platform capability tags***
Pegasystems Inc.
US
If the data page is sourced from a report definition, you can configure the report definition to remove duplicates. If you have other columns in this report definition, then you may need to source the page from a different data page that only has the one column to ensure distinct values.
The check box to remove duplicate rows is in the Edit filters section of the query tab on the report definition.
If the data page is sourced from an activity, you would handle the removal of duplicates in the activity.
Another option would be to source the multi select control from a clipboard page, this page being sourced from the data page with the duplicates, removing the duplicates as you iterate through the data page and append to the clipboard page.
Hope this helps!