How to scrap only one row from a table?

Help
1

I have a table from which I have to scrap a single row using data scraping. How can I achieve this?

2

Scrap the data, retrieve it in a string. Then split the string to gain the content you actually need.

3

@vivek_Chowdary,

Use Data Scraping to read table and will give you output as DataTable and say ‘DT’.

To read first row from DataTable - DT(0)

1 Like
4

@lakshman I need to extract the row where Year = 2018. How can I do that?

5

@vivek_Chowdary

If it is possible, you can try like this way also

row = dtTest.AsEnumerable.FirstOrDefault()

Thanks,

Pradeep Sridharan

6

@vivek_Chowdary,

Try below one:

DataTableName.select("Year = ‘2018’ ") - It will give you array of data rows as output.

7

@vivek_Chowdary You can use for each row activity then use if activity to choose what row of the table you want to get. Sequence.xaml (8.8 KB)

8

@lakshman Its not working. I am getting the following error:

Screenshot%20(56)
Screenshot%20(56)1920×1080 153 KB
Screenshot%20(57)
Screenshot%20(57)1920×1080 166 KB

I am trying to get the row with year=2018 from that table above.

9

@vivek_Chowdary,

Follow these steps:

  1. First scrape Data from Website and will give you output as ‘DT’.
  2. Then apply filter - DT.select("Year = ‘2018’ ").copytodataTable and store output in variable of type DataTable and say ‘NewDT’
  3. Then use Output DataTable activity to convert dataTable to string and pass NewDT here. Then display output string using message box.
10

@lakshman I am still getting the above error!!

11

@vivek_Chowdary,

Could you please share your workflow with me and need to check once.

12

These should work.

  1. Scrape Data then save sa DataTable
  2. Use For each row activity to iterate each row
  3. Use if activity inside the body of For each Row
  4. Input these as the condition → row(“Year”) = “2018”
  5. Inside then use assign activity to assign the values of the rows. (e.g. row(“mat”).ToString, row(“Inns”).ToString and so on)

Hope this helps

13

yes sure

14

@lakshman PS3_Final_Project.zip (25.0 KB)

15

@vivek_Chowdary

Please find the attached workflow. Here, Column name is ‘Year’ but you used ‘Column-0’. I changed now. Please run it and let me know. I am not able to open this site because my company blocked it.

PS3_Final_Project.zip (26.6 KB)

16

@lakshman Nope, it isn’t working. Same error.

17

@vivek_Chowdary

After scraping data and write into excel file and send me once.

18

Player Stats.xlsx (9.4 KB)

19

@vivek_Chowdary

I tried its working for me. Please find the attached file. Here, I am reading input data from excel and then filtered it and displayed. Run it and check once.

Main.xaml (34.9 KB)

Note: Just change the file path in Excel application scope and run.

20

no it isn’t working on mine.