Remove Duplicates From MultiSelect Control


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***


Keep up to date on this post and subscribe to comments

May 9, 2019 - 8:17am

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!