collection

Hi. I have a Collection containing a bunch of data. I wonder if its possible to filter it to get every fifth element of the collecation and append it to a new collection.

I need help to merge two collections with a different number of rows. I have one collection (the target collection) which contains all rows that I need to write this collection in a excel worksheet. The last column contains no data. These data I want to get from the other collection...

Hi I have a collection (read data from web page) , I wanted to to change one column data type to date time? How to do that? Intially that column is in text data type. From text to date time. How? Please give any suggestions?

Hi, I am trying to convert an excel document into a text file. I originally tried Save as, which didn't work, I tried writing to Notepad but couldn't get that to Word. So what I would like to do is either write the collection directly to MS Word or if not possible, write to Excel and then...

Hi Everyone, I am getting below error while loading web table into collection. My website page contains 300+ links nothing but sub pages (In below screenshot marked it with red ink circle) . I have to click each page and need to read table in that page. so after reading 15-20 pages some where...

Hello everyone, I have a work queue as a collection that I would like to use in another page but I couldn't understand the difference between unchecking "hide from other pages in the process" option and giving the variable in the end node of the page, then inserting it in the start node of the...

Hello, I have a collection of 20,000 rows and I can´t write them in an excel, I don´t know how to write it by code or if there is some other way, thank you.

Hey, I'm looking for some help I'm using Blue Prism to implement a solution, there is a decision stage where I check the following [Datos Segmento. Organizational Unit (Label)]<>"" But when I step run it sometimes gives the error The collection has no current row, during an online research...

Hi all, i have a Question regarding Collections Two collections with same fields and one collection has an extra field , and trying to merge or append the field and create a new Collection. Ex: A Collection has 8 fields Which has 4 rows containing Data B Collection has same 8 fields and...

I have a queue with unique certificate IDs, and I have a collection containing files. Each file has a certficate ID. I want to get a case from queue, go to the collection, open the file and search for the certificate ID. If it finds, rename the file and close it. If not, dont change the name of...

I'm designing a process that get its queue from a excel file (one line - one item) - inside browser application this one item gets a number of mobile numbers to do actions on. After all actions on the mobile numbers are complete, it returns to the excel file to write a status in the...

Hi everyone, I am currently creating an action which reads an xml report and detects error entries. I already have all necessary error entries in a collection. Now I want to concatenate all error entries (three fields: ID, affected order, error code) to a text (in a data item) which should be...

When I sort a collection with a DateTime column type the result of the DateTime will be different in the sorted collection. Each row will be 2 hours less, I think there is a problem with the timezone.

Hello, I'm new here. Can I ask if it's possible to have Excel values created as separate data items? Let's say I have a column of data item names and another column for its values. Also, if that's not gonna work, is it possible to create data items if I fetched the data to a collection first...

Hi All, I have the next problem. I have a collection with more than 15K rows and I need to write it in excel, but the problem is that it takes a lot of about 40 minutes with the Write Collection (Excel VBO) object, can the execution time be shortened?

Hi, Im trying to use a code stage to loop through a collection i have that contains one column. With each iteration the value in each row in will be updated. So far i have an input collection in my code stage(input_collection) . This collection contains one column with 1000's of rows. These...

Hi! that I must enter in the filter parameter... I'm passing this value but it does not generate the output collection: "RUN" = "1111-1" Help, please!

Hi Team, I would like to extract the values from the Collection based upon the Index Number Ex: Collection1 { User Name, Password, Address} I would like to extract the User Name rows with the help of Index number, To be in brief if we want to extract User Name values we have to mention...