I want to scrape data from the left table and for each row of it add the details from the right table, and then write it on excel.
I know how to scrape them, but I don’t know how to add the right table as columns for each rows from the left table… any suggestions?
Build Datatable according to your need.
Scrape the Left Table then for each row where values from your left table and get text each field from the right table and assign all the values to one datarow then write range to the DT.
Follow below steps
Use build Datatable activity to create final datatable.
Add columns names into it which you want in the final excel sheet.
use data scraping activity and scrap data of left table. datatable name=leftDT
3)Use for each row activity to loop through leftDT and inside loop use add data row activity like below.
This will add values into your final datatable.
Then use write range activity after for each row loop to create excel file (it contains the datatable of Finaldatatable that we created in the start).
Hope this will work
It worked! Thank you @ghazanfar very much!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.