How to extract multiple table’s data from the single web page into data table.
you can check the image i attached.
Welcome to the community
You can use a for each ui element activity and indicate full table…then the for each will take care of looping though each table…
Then use extract table inside the loop with currentelement as the input element…
Then use a merge datatable to merge all the tables into a masterdt
Cheers
Thanks for the response.
I’m facing an error while following the steps you provided. Could you please check and let me know where I’m going wrong?
“Currentelement” is DT variable ?
Check the variable type of Currentelement. It should be datatable type.
Yes, currentelement is DT variable but still it’s not working.
hello @Mohammad_Rizwan_03 ,
The output of the Extract DataTable activity is stored in a variable of type DataTable.
So your currentElement is of type DataTable Check…
Regards,
Dheerendra Vishwakarma
can you send error what you are getting that means the Screenshot of output panel
regards,
so in this error the activity is missing a ui element only no element is indicated so
indicate again
Regards
I am only able to retrieve data of single table, I am unable to retrieve data of multiple tables.
Can you please explain me the steps again.
Regards
Hi @Mohammad_Rizwan_03 ,
Can you try Table Extraction activity and enable the Extract data from multiple pages
Remove the variable from Datatable field in properties.
- Click in the editable field (of DataTable property).
- Press ctrl+k
- create a new output variable
probably this will solve your error since you are getting error, “Value of type Datatable cannot be converted to…” which I recollected from the image you provided .
Currentelement is to be given in input element field of extract datatable which is under target
And you nees to create a datatable variable
And one more to merge all tables into one table
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.