Filter Data Table Activity - Webdata Scrapping

Help
, ,
1

Hello Experts, I am using the ‘filter data table activity’ , to filter a ‘DataTable’ extracted from a DataScraping done in a website. The problem is the following error “column type is not supported”

Below the table generated using the ‘Write Range’

image
image840×427 90.6 KB

Sequence
image

Please, how can I solve this?

Any help would be really appreciated. Thanks!

2

Please show setting of Filter Data Table activity

3

Here it is.

image

First I tryed with the name columns “Job Title”, “Company” and “Salary”

4

@Jeff_E - pls try below with assign activity

dtTestJob =vDataTableIndeed.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()

5

@GBK

Hi, thanks for the answer.

I tried it, but didn’t work. First gave me a error, that i solved using this method

Then, the robot runs without error, but the rows in the datatable that contains empty fields isn’t deleted.

Please, check the files.

Data Extraction Job Sites.zip (977.5 KB)

6

Hi,

Please remove the last AND condition in filter setting (by click on X button) then it will be ok