I am facing an issue extracting data from this screen. How could I retrieve the debt displayed here? When I use the ‘Extract Data Table’ activity, it returns the table in a disorganized manner, making it challenging to employ a robot since it doesn’t follow a consistent pattern.
I was considering perhaps using some intelligent agent…
What approach would you recommend?
As you can observe, the payment installments consist of two rows: one indicating the amount for the first due date and another for the second due date. Additionally, there might be more rows (e.g., installment 3) or perhaps just one (e.g., installment 5). I only need to report the amount the client owes, which is the sum of unpaid installments. This presents a new challenge, as it requires summing not all the amounts from all rows but rather the last amount of each installment where the final column states ‘Installment Canceled’.
Can you show the extraction output please..how it looks..may be can write it to excel and show here
Also as per screenshot looks like column page might help in getting all rows that you need to sum..if so get only two columns in extract page and the column you need to sum..and filter page column with page value and then sum the filtered values
Hello! Thank you for your response. I utilized the ‘Filter Data Table’ activity to exclude columns that do not equal ‘Deuda Cancelada’ (‘Debt Settled’).(cells C3 and D3 should not exist and shift the content to the right).
Subsequently, I exported the filtered data to an Excel file.I attached a screenshot of the file. As you can observe, the columns are not interpreted correctly, as they are rearranged in different positions
