Search results

Hi All, I have filtered my collection to show me only the rows I require. What I would like to do now it total the column PKWh1 What is the best way to do that?

Hi Team, I am not sure what to populate in the first row number & Last Row Number , the number of rows is likely to be dynamic

Thanks Sachin, this worked perfectly :)

Hi All I am setting up my load queue process. I have extracted a list of folders into a collection I would like to set the Item ID in my queue to be the value from "Name" in the folders collection I am unable to work out what action to use to do this.. Any help appreciated

Thanks Sachin I have checked and the handles are all correct. I have run again and now this is the error I am getting Your help is appreciated

Hello I am wanting to open a PDF in word, copy the data from word and paste into an excel spreadsheet. I will then create a collection from this spreadsheet I have created the following process The issue I am having is that the following errors occur I am not sure what I am doing...

Hi Sukesh What if the column names are dynamic so I do not know what they will be each time? Thanks :)

Thankyou, sorry for the silly question but how do I read/extract the entire row?? Thanks in advance

Hi Guys, To explain to you my process I have an email that comes through with a spreadsheet attached The spreadsheet that comes through is dynamic, the worksheet tabs can be called different things and the cell locations differ. I want to extract only certain information but don't know...

I have an excel spreadsheet that changes each time it gets sent through There could be 1 line of data or 20 I also need to be able to get data from the other tabs

Thankyou Sachin, this worked a treat :) Really appreciate it

Thankyou Sachin, this worked a treat :) Really appreciate it

Hi Everyone I have a collection with multiple rows I want to save the values from NMI into a single row in my main collection so they appear like this in the field VE....., 64...... So I only end up with a single line of data in my main collection. I am not having much luck with my...

Hi All, I have a collection that contains a header but Blue Prism isn't reading it as a header. I have tried the collection maninpulation utility action : But get the below error when trying to run the stage... Any help appreciated

Perfect thankyou :)

Hi Everyone, I have a collection that contains extracted data What calculation would I use to determine if the Rows are greater than 1? I can't compare the collection and Rows isn't a field.. Thankyou

Thanks heaps, I have created a process (Download and Save) and it seems to be working but once the folder is created it is not assigned to the email so I have no way to join them. Is there a way to assign the folder path once it has been created back to the relevant email I want to be able to...

Hello I am trying to create a process that completes the following steps Reads outlook for emails and extracts emails with Email Body Saves the Body of the email and the attachments to a unique folder I am having trouble working out how I can create 1 folder for 1 email and download all...

Hi Everyone I am pretty new to Blue prism and have a question about extracting specific data from an email body As an example the email I received contains the following Customer Details Site Name: Blue Prism Test Site Address: Blue Prism Lane, Water, Vic, 3016 ABN: 89 411 555 555 NMI...