Function to remove duplicates in a table in Design Studio

[Sindhu13]

We would like the ability to remove duplicate rows from a table. Currently, we rely on a combination of the Filter Table and Remove Row functions, which can become tedious and inefficient when working with tables that contain multiple columns.

[arpit.alne1]

Hello @Sindhu13 

You can use code stage to remove duplicates. 

Paste this code into Object Studio - 

<process name="__selection__Utility - Collection Manipulation" type="object" runmode="Background"><stage stageid="3f07a9ec-9613-4e59-923f-6f81763348f3" name="Remove Duplicate Rows" type="Code"><subsheetid>87cd240a-66f3-47ad-8819-9fb61c89137c</subsheetid><loginhibit onsuccess="true" /><narrative>From within the collection</narrative><display x="15" y="-15" /><inputs><input type="collection" name="In Collection" expr="[In Collection]" /></inputs><outputs><output type="collection" name="Out Collection" stage="Out Collection" /></outputs><code><![CDATA[If In_Collection.Rows.Count>0 Then
   Out_Collection= In_Collection.DefaultView.ToTable(True)
Else 
Out_Collection= In_Collection
End IF]]></code></stage><stage stageid="0bd80cd4-2f25-4f7f-b227-c6ec0a7297b8" name="In Collection" type="Collection"><subsheetid>87cd240a-66f3-47ad-8819-9fb61c89137c</subsheetid><loginhibit onsuccess="true" /><display x="-165" y="-15" w="120" h="30" /><datatype>collection</datatype><private /><alwaysinit /></stage><stage stageid="747a1f6c-3d56-4684-bd92-73676760aa0c" name="Out Collection" type="Collection"><subsheetid>87cd240a-66f3-47ad-8819-9fb61c89137c</subsheetid><loginhibit onsuccess="true" /><display x="-165" y="15" w="120" h="30" /><datatype>collection</datatype><private /><alwaysinit /></stage></process>

Let me know if you require any assistance.

Thanks

[Sindhu13]

Hi Arpit, Thank you for your response. I have raised this idea for Chorus BPM Design studio and not for Blueprism.