Bot reading blank row, how to avoid it

I am using two excel to write the values into one excel. so in this process bot reading blank row also…

Hi @Manju_Reddy_Kanughula

You can try with this expression

Not String.IsNullOrEmpty(Currentrow(“YourColumnname”).tostring)

Then → You can go ahead with the process

Else → You can iterate the next transaction

Regards
Gokul

I am not getting where should i write the given code.

Hi @Manju_Reddy_Kanughula

Use Another If activity above your if activity

Some thing like this check out the image

Regards
Gokul

Hi @Manju_Reddy_Kanughula

Try to use filter activity and assign column name=empty (and select remove option )

It will remove all empty rows.

Thanks

Remove the >0 in the expression @Manju_Reddy_Kanughula

image

OT Excel having SH1339 is the last row… Output Excel have SH1344 is last but there is one more row for total…

image

Have you Tried like this? @Manju_Reddy_Kanughula

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.