Set html table header as rpa collection header Ask Question

Question

I've managed to get a HTML table and change it to collection. However, I would like for the table header to become the collection header. Is it possible to do it? Thanks.

Below is for further details on how I take the table element and change it to collection.

The path that I'm getting from the HTML table inside application modeler:

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

Then I use the 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....

Answer 1

You can use the action called "Set Column Names From First Row" in Utility - Collection Manipulation.  to easily set it.