[Blue Prism] Tell me how to assign the value obtained from the two column values in Excel to a variable

[Apple]

• Assumptions

What you want to do is as described in the subject line.​

The result is that the Collection data read from Excel​

I would like to take the form of assigning to a variable so that the value can be used universally.​

​

* Here, the Row of this Collection data is dynamic and there is one or more rows. In contrast, column is only 2 columns.​

• The problem / error message you are experiencing

At the moment,​

Using Excel VBO​

From the instance generation, read the data written in two columns in Excel,​

You can get it as Collection data.​

​

I can't​

This number of rows is dynamic,​

First of all, I don't know the procedure for substituting the value of Value for the obtained value Key into a variable.​

• What I tried

We also imported Utility Collection and Collection Manipulation VBO, and made various trials and errors.​

• result

It leads to the above current situation.​

First of all, I would like to know the procedure for substituting Excel data (key, Value) of dynamic row number into different variables for each row.​

• Supplemental information (FW / tool version, etc.)

BP 6.6​

MySQL Express 2017​

 

[Avgupta]

It is simple.

You have got your data from excel into a collection. Now what you can do is use calculation stage -> concatenate function under text, and concatenate data from 2 columns of the collection into a single data item.

Eg:
My collection name is Data.

Collection structure:

Col1 col2
-----‐-------------------
A G

So to concatenate data from col1 and col2 into a single dataitem,

Use calculation stage and use the below expression:

[Data.Col1] & " " & [Data.Col2]

** Space has been added between the values .

So the output of the dataitem will be

A G

Let me know if you face any problems with this.

 

[Apple]

I was able to solve the question myself.
However, the contents of the answers made me study very much.

Thank you