I'm new to both coding and Blue Prism and i'm looking for some support.
I have a a project were I need to compare data from two collections ("Collection_1" and "Collection_2") and pick out any unique rows from "Collection_1" and save in "Collection_3".
Both collections only consists of...
I'm looking to summarize all values in a specified column in a collection through a code stage (not looping).
In this collection called "Collection", I want a sum of all values in column "Numbers".
I don't read or write C# very well, so can someone provide a code that...
I am coming to you with the following issue:
I am trying to get all the items from a tree view in Microsoft Dynamics AX 2009. The tree items are open orders that I need to loop through and check and modify different values in each of them.
My current idea is to get somehow all the...
I am stuck in below placees while automating one solution, please help me with this.
- I need to write to Excel Cell : Value is 0001234, But when I am using Set Cell Values and saving it. Value is automatically changing to 1234, after save. How to solve this ?
- There is need...
I am reading range of excel sheet into a collection. There are 1650 rows but it is extracting only 17 rows into output collection. I have used number of rows and given input as end cell. Could you please help me what might be the issue?
In the collection I have several columns named:
What I have to do is check where the name is entered and transfer this value to the new table. I want to create a Name column in the new table and put the obtained data there.
I thought about doing it in two...
I am retrieving some information with Blue Prism from one API, and I receive a collection as the output. The problem is that I do not want my collection to look like this. I want to receive one collection with one row where I will have all of the employees listed, not 1 employee per 1...
I'm currently converting an Excel file to CSV.
Step 1: Get data into collection
Step 2: Convert collection to CSV
Step 3: write it into a file.
It works, but there is a problem with Data format error.
Excel value - 9781621577720
CSV value - 9.78162E+12
I'd like to know if...
I am looking for a simple straighfoward way of merging 2 collections. I know that for example in python( i think SQL is as easy) this can be done in one line:
merged_coll = coll1.merge(coll2, on="column_name", how = 'inner'). Is really no other way in B but that silly looping of one...
I'd like to get ideas and tips for how to compare multiple rows in a Collection to group them together. The purpose is that the larger item (bytes) from the same date will be used for one purpose and the other for another.
Items - Bytes - Date FieldX
I'm new at RPA/Blue Prism.
I've got a problem with the Action "Get Worksheet as Collection".
In the excel sheet are hidden columns. These are not found. Blue Prism returns error message: Internal: Could not execute code stage because exception thrown by code stage: Column 17 was not found...
There is a client Application :in application after process of Account in Comment section we need to provide comments , the comments template will be in Excel , there will be around 10 accounts ,selection the comments is based on process of Accounts.
for ex comments in Excel: Client ABC...
I had query while performing one action, I want to convert column A row values as header to Column B in a colection in BLUEPRISM. Kindly plz anyone help us. Thx
sample O/p should come as ----- Firstname as column with value pawan
I'm currently working on a process that reads in a series of virtual machines from an excel sheet, finds their respective states, and stores them together into a collection (Excel Bot Names). My goal is to send out an email displaying each machine's name and it's respective state, so...
I am using the Natural Language Google API in Blueprism. This API outputs a collection which contains sub collections. I want to reference a sub column from this collection. However, If I simply use the collection name.sub collection.sub collection.field I get an error. Am I doing something wrong?
I have been reading a couple of threads about saving a collection to CSV and they all seem to want to use comma as the delimiter.
In the Utility - Strings there is already input/output and code for this, but using a comma, how would one go about changing the delimiter to say | or &&...
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...