collection

[gayatri]

how to remove duplicate rows in an outputed collection in blueprism.
how to compare 2 rows in an dynamically running collection

 

[VJR]

Hi gayatri,

There is a similar post on the forum here
http://www.rpaforum.net/threads/how-to-get-unique-values-from-a-collection.757/#post-1872

In this link there is a comparison made between only 1 field of the collection. You can use the same logic to check other fields too and copy to the output collection only if values of all the required fields of each row are matching.

If you have lots of data to compare then to make things faster you might have to use a Code stage either in Visual Basic or C#.
Below is a post on how to do it in C#.
http://www.rpaforum.net/threads/how...sheet-using-c-code-in-blueprism.897/post-2510

 

[gayatri]

thankyou for your reply,but it is giving same rows as in input collection.In the input collection i have current values in that i should remove duplicates.In the logic in intial values they did it can be applied for current values also.

 

[VJR]

Hi gayatri,

If it is giving same rows as in Input collection can you check what does the Found flag return while stepping through (F10). Also do check if all the input and output parameters of all the stages are given correctly.
If it doesn't work as expected then are you able to share any screenshots?