Data scrapping from html table having alternte empty row

datatable
excel
activities
p_qa

#1

Scenario:html table with alternate blank records

Steps to reproduce:data scraping

Current Behavior: records till first blank row is fetched

Expected Behavior:all records to be rretrieved

Studio/Robot/Orchestrator Version:2017

Last stable behavior:
Last stable version:
OS Version:
Others if Relevant: (workflow, logs, .net version, service pack, etc):


#2

Hi Lawanya,

Do you have a link with a html table like that? So we can test?


#3

it is in client side. i am trying to see if the aspx page which loads the result has sub tables also and scrap them seperately


#4

If this is still an issue for you, I saw something that sounds similar not long ago. In this specific instance I think the issue is that the table is actually being dynamically filtered at RT, based on selections you make on the page. I think the scrape returns a normal row for the rows it can see, and an empty row for the ones it can’t

Here’s an example of one of the URLs we saw this on:

Can’t offer any suggestions on how to fix the scrape, beyond simply ignoring or deleting the empty rows from the target datatable. For this specific page we opted not to scrape the table but to DL and use the linked Excel file instead.

ddk