I am automating a website and I am trying to extract a table but don’t want to extract all the columns from the website. Below screenshot is the example. I don’t want to extract the Action column so what should I do?
Any help will highly be appreciated, Thanks!
in the extract table activity, in each column exist a trash icon, near to the settings icon, just click on it and it will delete the column
Another approach would be extracting the entire data in an easy structure & then only keeping the necessary columns.
As I believe this is the ACME assignment process, you can use this query in an ‘Assign’ activity:
yourDt = yourDT.DefaultView.ToTable(False,”col1”, “col2”, “col3”)
Let’s say, in your case, if you only want WIID, Description & Type, you can process the entire table like this:
yourDt = yourDt.DefaultView.ToTable(False, “WIID”, “Description”, “Type”)
This will only keep the specified columns as you required.
Hope this helps,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.