Recent content by AshutoshMahale

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.

Hi @Gaurav Sharma My server is always in active stage, Also the control room is active for my entire session. Still getting this issue.

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...

@Emil.Tophoej & @VJR It worked for me. Thanks a lot for your help!

Hi @VJR, What can be done if I have to extract just 2 or 3 columns in a excel and get it into a single collection?

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...

@DanielTorres Lets say a process takes roughly 8 mins to execute in Process Studio, how much approx time should it take in control room to execute?

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 Thanks a lot! It worked perfectly for me. :)

@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.