How to let the bot stop when the next row is empty?

As now i had done as Pic 1, which is get the data from excel as shown in Pic 2, what should i do to prevent the bot take the whole sheeet including total?For example,if row 23 no data,thn it will stop there. Thankyou

here is the Pic 2

In the current process, add one more activity Filter DataTable.

In the filter DataTable activity, remove the rows which are empty and contains Total as shown in the screenshot below.


Karthik Byggari

can i know where should i put this?

After Read Range activity.

Hi ,the copied data will de duplicated and the bot still taking the data “Total”

The values (conditions) given in the filter data table are case sensitive.
Please check by updating value to TOTAL