How to handle duplicate records in a queue ?
1. Can we handle a queue like it should not allow adding duplicate record in a queue?
2. If any duplicate records exist in the queue then how can the bot identify the same and ignore the record ?
So you are saying that if we have an excel sheet and if there is a duplicate value in a column (which is our key field) then when the queue will be loaded using Add To Queue then when the duplicate row gets added automatically queue will recognise and it won't allow to enter ?
@Kamal and @Pete_L Unfortunately that's not how it functions.
The key field in Work Queue can definitely contain duplicate values.
There is no internal check within Blueprism to avoid Duplicate Queue Items.
It can be achieved via 2 methods:
1. The collection being inserted in the ADD TO QUEUE action should contain unique values (Use Remove Duplicates from Collection VBO to obtain unique rows in collection)
2. Before inserting a record in Queue, use action "Is Item in Queue" from Work Queue VBO. It lets you compare the key on new item with all the existing items in the queue. Based on the output (True/False), decide whether to insert the record or not.