I have a horizontal table on a website that has the html structure something like this:
There are about 30+ rows in the table. When I use the data scraping method it will only pull back two columns, but the header is also needed to ‘act’ like a column for purposes of the automation I’m trying to complete.
So get me Value1 and Value2 for Header1 for example
So on the website it looks like:
The Data Definition from the scrape is like this.
I can only get 2 columns, those columns seem to change if I tweak the get_columns_name number…but even so the headers are all squeezed into the header of datatable.
I’ve managed to do 3 separate datatables to get me the data but now also facing an issue of merging all the tables:
Data Definition to get individual column:
tag and class just updated for other columns.
So I guess my question is:
1 - Is there away to get the scrape to work so I have all three columns
2 - If not how can I merge the 3 tables. Each table having different columns
I’ve looked at various articles on merging tables and data scraping and they have only got me to this point