In this image I have to extract the entire table of nonexpense details and expense details and I have to append the extracted data to respective columns in another excel how to approach in studiox
first use fin/replace and search for hweader values which will give the row number where the data start
use them in read range and read the data as needed
cheers
@govindreddy_nagireddy
Hi, Below you can find an image for reference purposes
Also, you can use ‘Find First/Last Data Row’ activity to get last row with populated data. + Filter Data Table to remove empty lines.
Property ‘Visible Rows’ of Read Range to be adjusted based on your requirement
Ok sure I will try it
It worked for me but while
extracting data for expense details I am getting the
data like numeric values for which we don’t have data, for ex: in this image I have data till 7 row but I am getting all the numeric values, how to avoid the numeric values from 8
Hi @govindreddy_nagireddy; before the read range, you can use “Find First/Last Data Row”, it will return the last row number populated on a specific column.
Then, on the read range activity you can build your range
