Extract data from only where the second column exists

Help Activities
, ,
1

Hello guys, I am extracting data for multiple items from a website and I want to extract a table but only where the second column exists like in this table:

image
image1026×574 19.6 KB

So I want to extract Type, Coating, WTC, etc
And these items hava different tables.
Anyone have any idea how can I do this ?
Thank you!

2

Hi @Ionut_Frincu ,

Are you able to use Data Scraping to Extract the Two Columns as a Datatable ?

3

Hello @supermanPunch I can extract data scraping whole table, but I only need the table to don’t have the second column empty if you know what I mean :slight_smile:

4

Hello @Ionut_Frincu :slight_smile:

If I understood correctly, do you need just extract the columns that contain values in second column?

5

Yes, that’s right, and I prefer to extract all these items as a table :slight_smile:

6

@Ionut_Frincu , If we can Extract the Two Columns as a Table, I suppose Half of the Work is Completed.

We just need to Filter out the Datatable to keep the rows which contains values in both the Columns.

we can do so using the Filter Datatable Activity for Starters, if we do not get the Expected result we can move on to Linq.

image

1 Like
7

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