Can anybody explain what's the difference between match index and ordinal? I have gone through all the documents but didn't get any firm answer.
It would be good if someone explains this with an example.
I'm using a development server and I keep getting this message, every 5 minutes.
"The AAE Client has been disconnected from Control Room. Please save your work as the AAE Client will exit shortly."
A few minutes later the AAE Client closes.
Any ideas on how to solve this problem?
Hi,
These are the required images. Can't post the collection data as its confidential. But the contents include total 22 of text, number & datetime columns with approximately 5000 rows.
Also I tried it with the original MS Excel VBO & modified Excel VBO as well, both are giving same result.
Hi @Sukesh Kumaru,
The data is getting inserted 1 row at a time when I do show workbook action due to its huge content in each cell (large texts), so even if I split the collection it would continue the same thing.
Hi,
Is there any time efficient way to write collection data into excel? I have some 5000 rows and 25 columns to be copied. (I have already used write collection action & data insert through oledb, former one is taking too much time & in latter one process is abruptly ending giving an error...
Hi @VJR,
Your solution is perfect for less no of columns, but I have a situation where I have to delete multiple columns (>1000) and retain just 1 column in the collection. Deleting 1000 wont be that much time efficient as it would run inside a loop, instead is there any other functionality...
Hi,
Can anybody tell if there is any difference between average process execution time in process studio (in Fast run mode) and control room in blue prism?
TIA!
@VJR My task is as below:
1) Keep on appending a row in collection from a separate collection
2) Compare the latest added row data with the 2nd last row
3) If its found as same then delete the 2nd last row
4) If not then leave as it is
5) Repeat steps 1-4 again
Reversing the collection which...
Hello,
I have scenario where I have to trigger a mail through Mapiex after confirming a condition. As per the condition, the font color of some values in a collection needs to be changed & have to send that collection as a table in mail body, including the changed font color. Is there any way...
@VJR Its a feasible solution & I tried it before suggesting by @DanielTorres. But its not quite time efficient as I am dealing with 40000+ rows in the collection & each time appending a row in that collection.
I am not able to delete the 2nd last row because when the loop reaches last row, it cannot access the 2nd last row for deletion as the current row in progress is the last one. Is there any functionality in BP where I can delete the 2nd last row after comparing it to the last row at that instance?
@VJR Thanks for the reply!! Is there any way to delete the 2nd last row? I also have a condition where I have to compare last 2 rows of collection, and if they are similar then have to delete the 2nd last row, keeping the latest row intact.
Hello All,
I have a situation where I have to confirm a logic and if it's true, then I will have to remove the last row in a collection. Is there any provision in BP for doing the same?
PS: I have used the Remove row action in Collections VBO, but its removing the 1st row of collection instead...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.