How to extract the structed data table whose length of column is changing every time

Help Studio
, ,
1

Hello everyone, I am facing an issue while trying to extract a data table using data scraping. The problem is that the column of the table keeps changing, which is causing my automation to fail. Can anyone suggest a dynamic way to tackle this issue? Your guidance would be highly appreciated. Thanks in advance!

image
image878×334 13 KB

image
image863×327 8.94 KB

2

Hello Kumar_Sahu_Sameer, please reply if you get the solution

3

Is this an HTML table? If so, I recommend using Find Children (set to descendants) with a filter of tag=‘TR’ to get all the rows into an array, then loop through that row array. Inside the loop, use Find Children with currentItem set as the Element, and filter set to tag=‘TD’ to get the cells in that row. Then loop through the cells and use Get Text to get the value in that cell and then use Add Data Row to add those values to a datatable.