I have a data table which I am scraping from a website and that works fine. The first issue is that I am deleting two columns in the data table and I can see the columns being deleted but when I view the data table, the columns are back. Here are the images
Kindly let us know what is been tried here in the workflow
As stated you told were deleting columns from a datatable extracted
But here in the image there is no Extract Datatable activity
Is it like we got a datatable and trying to delete from the front end UI of excel application
If so we can directly use REMOVE DATA COLUMN activity which will help us to delete the column we don’t want from the datatable
Then we can use the Write range activity or sort datatable activity with column index mentioned (column index usually starts from 0 for the first column)
@supermanPunch
If you look in the first and second images above, the column deletes start with the Select Range activity and goes down to the Save Workbook activity. This deletes column A and column B
@Palaniyappan
Thank you, I am scraping a website in a prior activity and then I’m saving it here and trying to delete columns. I’ll try the REMOVE DATA COLUMN activity today