Can the html table header used as rpa collection header

0 votes
I would like for the table header to become the collection header. Is it possible to do it?

I've managed to get html table and change it to collection.

The path that im getting from the html table inside application modeller:

/HTML/BODY(1)/DIV(2)/FORM(2)/DIV(1)/TABLE(1)

Then i use Read stage and choose the table as the element and set Data as Get Table function and save the collection.

The collection result produces:

On header - Column1(text), Column2(text)....

First Row - Department, Name.... || This supposed to be the header

Second Row - DepartmentData, NameData....
Nov 16, 2018 in RPA by findingbugs
• 3,140 points
148 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

I got the action called "Set Column Names From First Row" in Utility - Collection Manipulation. 

Do you have it too?

If not, then here's the code:

Dim iThisColumn as integer = -1
For Each Column As DataColumn In Input_Collection.Columns
   iThisColumn +=1
   Column.ColumnName=CStr(Input_Collection.Rows.Item(0).Item(iThisColumn))
Next
Output_Collection = Input_Collection

This will serve the purpose.

answered Nov 16, 2018 by Jino
• 5,520 points

Related Questions In RPA

0 votes
1 answer

What do you by mean by the term Information Collection in RPA?

In RPA, robots need raw data or ...READ MORE

answered Jan 17 in RPA by DataKing99
• 8,100 points
57 views
0 votes
1 answer

RPA - Scheduling the workflows in UiPath

you have to create a package of ...READ MORE

answered May 4, 2018 in RPA by wrecker
• 3,090 points
198 views
0 votes
1 answer

Can i find the control type in UIPath?

There is no direct way of checking ...READ MORE

answered May 16, 2018 in RPA by Vardy
• 2,280 points
29 views
0 votes
1 answer

how can we imlement alerts/ email notification in RPA

Hi Bijoy, Yes we can do it in ...READ MORE

answered Jul 11, 2018 in RPA by Priyanka
• 140 points
75 views
0 votes
1 answer

What are the different tools available for RPA?

There are many tools available for implementing ...READ MORE

answered Jul 10, 2018 in RPA by Atul
• 5,470 points
36 views
0 votes
1 answer

What is the suitable programming language for DIY RPA tool?

We are working on an Open source ...READ MORE

answered Jul 19, 2018 in RPA by Atul
• 5,470 points
491 views
0 votes
1 answer

What is code segment in Blueprism and how to implement it?

Blue Prism - Code Stage The code stage ...READ MORE

answered Sep 28, 2018 in RPA by Priyaj
• 56,120 points
643 views
0 votes
1 answer

Error : Failed to perform step 1 in Navigate Stage '-----' on page '----' - Not Connected

Do you have Attach bookmark created? When ...READ MORE

answered Sep 28, 2018 in RPA by Priyaj
• 56,120 points
1,969 views
0 votes
1 answer

Spy an active accessibility combobox in blue prism?

My ComboBox is standard HTML Combo Box(Element ...READ MORE

answered Oct 1, 2018 in RPA by Priyaj
• 56,120 points
582 views
0 votes
2 answers

RPA tool for C# Developer beginer

Hi! You can try Rpa Suite for Visual ...READ MORE

answered May 10 in RPA by AndrewNJ
314 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.