cancel
Showing results for 
Search instead for 
Did you mean: 

Pulling Collection by Row Data

JoshHarris
Level 2
​Is there a way to pull a collection from excel by row data instead of by column? For Instance the data is entered into excel as shown below:

Name             John              Jack            Jeff
Age                23                  22                24
Sex                M                   M                 M
City                NYC              STL              SEA

In this scenario I would want Name, Age, Sex, and City to be the Fields in the collection

I realize I could manipulate the excel file and organize it into columns, but I'm hoping to find a way for blue prism to pull the data into a collection as is.

------------------------------
Josh Harris
Solution Designer
Boeing
------------------------------
1 REPLY 1

AhmedBasheer_M
Level 3
Use the Transpose Collection Action under Utility - Collection Manipulation.

------------------------------
Ahmed Basheer M
RPA Developer
Capgemini India
Asia/Kolkata
------------------------------