How to use Extract Table for the extraction of few columns

[Muhammad_Anas_Baloch]

Hey everyone,

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!

[fernando_zuluaga]

Hi @Muhammad_Anas_Baloch

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

Regards!

[arjunshenoy]

Hi @Muhammad_Anas_Baloch

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,
Best Regards.

[Muhammad_Anas_Baloch]

Thank you, it worked.