I am trying to read a table from a website using “Data scraping” and storing it in a data table and deleting the first 2 rows in the data table. I am facing issues with the data table and choosing the column name while filtering the data table.
Step:1 scraping the table from the website. It works fine and below is the image that I get while trying to scrape the website.
The headers from the webpage are updated as rows and I can see new Column name as “Column-0” in the extract wizard.
Step-2 I try to write the data table into a worksheet but no headers are updated in the sheet. Only from Company name row, it is updated in the sheet.
Step-3 I trying to delete first 2 rows with “COMPANY NAME” in the first column but I am unable to use Select query with Datatable. I tried using “Column-1” but getting “column name not found” exception.
Can someone help me on deleting the first 2 rows?