Hi Friends, Need help with extracting data from table in a website using Data Scraping.
Here is the scenario, I have to process each parent record individually and there are sub records associated to each parent record. So I created a for loop to loop through each parent record and within that I am using Data Scraping activity to pull the sub records in a datatable. Now sub records doesn’t have consistent data for each parent record like for parent record 1 sub records may have data for certain columns and null for others while parent record 2 sub records has data for certain other column which doesn’t match with sub records data of parent record 1. Due to this the datatable which I am creating for sub records doesn’t have consistent structure and due to which I am not able to extract data from that datatable using “ExtractDataTable(0)(2).ToString”. Also below are the issue with datatable being formed.
- It just pulls the data and not the headers from web table and due to which I need to access the data using “ExtractDataTable(0)(2).ToString”.
- It shows additional rows other then actual data which are not highlighted in attached snapshot.
Attached are the snapshot to support the above scenario.
Please share your input how to best handle this scenario.