How to Pick Some Columns for Data Scraping

Help Studio
1

Hi! I am currently trying to scrape the data from a table in a website. The table contains many columns that I don’t need. Is it possible to choose some columns are put a range of columns when data scraping? Thank you.

2

HI @Archie

You can achieve this by two methods as far i know

Method 1

  • While Data scrapping the table the wizard will be shown that can it get all the values from table
  • In that you need to select the NO and select the columns manually and give your column name and extract correlated data of all column you need.

Method 2

  • After datascrapping the table
  • Use Filter datatable and Go to Output column section and click on Keep radio button and give your column names one by one by clicking “+” on it
    image

Regards
Gokul

3 Likes
3

@Archie

Once the data scraping is done then it will store into the datatable

So you can use Filter Datatable and give which columns you need as below

image

Hope this will help you

Thanks

2 Likes
4

Hi @Archie

we can try editing the metadata in extract data table properties and select the desired column we need?

Or after extracting we can try below expression to get the column you need!

ExtractDatatable.Defaultview.Totable(False,“Columnname1”,“Columnname2”…).CopyToDatable

Regards

2 Likes
5

Thanks! I did the method 1. I wasn’t aware of the “Correlated Data” Button. I managed to save some seconds on creating the datatable.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.