Solved Remove row values dynamically

rpaccount

Member
Hi. I have a collection and would like to remove row values dynamically blue prism.
The values are going through a loop and i'm using remove row in action from business object Collections.
However, it isn't really working. I was told that i need to use the remove row action with something else.
Would appreciate if anyone could take a look.

Thank you! :)
 

Sukesh Kumaru

Active Member
Hi. I have a collection and would like to remove row values dynamically blue prism.
The values are going through a loop and i'm using remove row in action from business object Collections.
However, it isn't really working. I was told that i need to use the remove row action with something else.
Would appreciate if anyone could take a look.

Thank you! :)
Hi,
Could you please share the process flow, so that i can understand it clearly and i can solve your issue possibly.
Thanks,
Sukesh Kumaru.
 

VJR

Well-Known Member
Hi rpaccount,

Give the parameter for your name of collection in double quotes as below.
This is because as shown in the parameters it accepts the name as Text.
"Coll1"

Secondly, to delete only 1 row (the topmost row) use this action individually.
Else to delete all rows one at a time then use it within a loop.
 

VJR

Well-Known Member
Hi rpaccount,

Did you get a chance to implement the suggestion I made above for 'Remove Row'.

Give the parameter for your name of collection in double quotes as below.
This is because as shown in the parameters it accepts the name as Text.
"Coll1"
 

VJR

Well-Known Member
Hi VJ
I did :(
It gave me : Internal : Failed to find any collection stage with name

Thanks!
No buddy, I didn't see that done in your screenshots. They were in the form [CollectionName.ColumnName] which is incorrect.
You need to use only the collection name enclosed within double quotes.
"MappedCollection"
 

rpaccount

Member
No buddy, I didn't see that done in your screenshots. They were in the form [CollectionName.ColumnName] which is incorrect.
You need to use only the collection name enclosed within double quotes.
"MappedCollection"

Oh. I thought you meant col1 haha. I put it as col1. Missed out the l in coll1. Thought you meant column1 instead of collection1.
No wonder it didn't work.

Thanks alot!
Once again sorry for the trouble.
 

VJR

Well-Known Member
Oh. I thought you meant col1 haha. I put it as col1. Missed out the l in coll1. Thought you meant column1 instead of collection1.
No wonder it didn't work.

Thanks alot!
Once again sorry for the trouble.
So how did it go after making the change to collection name enclosed within quotes.
 

lakshmis

New Member
Hi, Can you please tell me how to achieve removing a row from collection without using loop stage.
Example : In collection1, I have 500 rows and in collection2, 11 rows. So, matching rows has to delete from collection1.
So, I will loop Collection2 and using filter collection action in Utility-Collection manipulation (Collection In: Collection1 and Filter: Matching row)
Now, wanted to remove the matching row from Collection1.
 
Top