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,260 points
1,276 views

1 answer to this question.

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.

Are you interested in learning RPA? Enroll in RPA Developer Course now!

answered Nov 16, 2018 by Jino
• 5,810 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 18, 2019 in RPA by DataKing99
• 8,240 points

edited Jun 28, 2023 by Khan Sarfaraz 911 views
0 votes
1 answer

Which programming languages can be used in the Coding Stage of Object Studio?

Hi, you can use these programming languages ...READ MORE

answered Oct 18, 2019 in RPA by Jathin
4,610 views
0 votes
1 answer

Which of these items can be used in the control room ?

Should be option a. Process. READ MORE

answered Apr 13, 2020 in RPA by Kim
584 views
0 votes
1 answer
0 votes
1 answer
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
• 58,090 points
5,274 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
• 58,090 points
15,937 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
• 58,090 points
3,023 views
0 votes
2 answers

RPA tool for C# Developer beginer

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

answered May 10, 2019 in RPA by AndrewNJ
4,101 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP